Queries

<>=
I created this expression from other 2 expressions Expr3: IIf([Expr1]>[Expr2],"MISS","HIT") Expr1 is a variance from Field1 and Field2 Expr2 is Field2 x 2% Expr3 should be a "HIT" if Expr1 is < Expr2 or = should be a "MISS" but when I have a large negative qty is making it a "HIT" when it should really be a... 10 Jul 2008 13:25

Delete query
I have a table that has 20 fields and might contain duplicate information based on 3 fields(ID, LoanNum, date). How do I create a delete query that would look at each record and based on those 3 fields delete 1 or more of the duplicates and leave the other? e.g., ID: 123 LoanNum: 44444 Date:01/01/2008 ID... 10 Jul 2008 13:25

Question on Query Comparing 2 values
Hello Group, I have 2 recordsets with the 2 exact same fields. I would like to perform a compound comparison of the 2 fields from each table. That is; compare recordset #1 to recordset #2 and get a returned recordset (recordset #3) that contains records where: - Field #1 from Recordset #1 equals Field #1 fr... 10 Jul 2008 13:25

Access SQL Question
I'm trying to UPDATE the value of a COUNT() operation into a field viz. UPDATE <table1> SET <field> = ( SELECT COUNT(*) FROM <table2> WHERE <table1.PrimaryKey> = 1; When I do this I always get the error message "Operation must use an updateable query". Anybody know how to do this correctly? thanks, ... 10 Jul 2008 12:23

A couple of text parsing questions
Question no.1 Eg, the following NORCREST, , WOODSIDE ROAD, , , BANCHORY, KINCARDINESHIRE, AB314EN How do I get "AB314EN" on its own ie. just the text after the last comma. Question no.2 Each postcode has either 3/4 characters followed by 3 characters. So in the above example I need a space to get: ... 10 Jul 2008 11:20

Simple Query Question, can't figure it out
Hello, Novice user here. I have two tables. One contains StudentName, ProgramSelect1, ProgramSelect2, ProgramSelect3 and a variety of other fields. The second table contains Contact information for Programs (Program, ContactName, Email, Location, Phone). I want to create a query that gives me the Student... 10 Jul 2008 11:20

Module problems
I have my queries,tables, modules, and macros all set up. Below is the function my module serves. I changed the name of a table, and it will not work now- I get a message box stating- "Could not find output table 'Final'." Which this is the table name that I changed- I changed it to FinalCR, now the module don... 10 Jul 2008 10:18

Crosstab
Hi I need your help once again I have a query that is a crosstab showing using the following SQL TRANSFORM Sum(qry_generelOEE.OEE) AS SumOfOEE SELECT qry_generelOEE.dpt, qry_generelOEE.yearnb FROM qry_generelOEE GROUP BY qry_generelOEE.dpt, qry_generelOEE.yearnb PIVOT qry_generelOEE.week; I use this as ... 11 Jul 2008 08:54

multiple condition queries
morning all hopefully someone out there can offer some assistance i am building an access application in which i wish to be able to intially look at all the data in a form view (sorted that bit out), and then be able to use a variety of drop downs to "filter" the data based on if anythng is or isnt selected... 10 Jul 2008 06:12

Picking up last 4 letters from a field
In my query I have an account account number that I only want to pick the last 4 letters. The account number has 8 numbers and text. This field is actually a text field. For example account number will be 11AS6792 I only want to get "6792" How do I do that. Thank you in advance. Cheers ... 10 Jul 2008 10:18