Search results

I need to match the most likely combination of two queries where query1 has [LASTNAME, FIRSTNAME] and [last4ofSSN] query2 has [LASTNAME, FIRSTNAME, MI] and [FULLSSN]. Annoyingly last 4 of SSN can duplicate and names do not match exactly between the two queries.

when I do datediff(expr)<=0 and datediff(expr)>=2 and the result being evaluated is 1, why does it not count as true? Better yet, how do I fix it so it does?

I am attempting to take the current time and subtract another fields time and get a number of months in decimal format and then compare it to a range to set criteria for a query. How do I enter ((now()-[arrivaldate])/30.4)>=0 and make it see if that value is truely >=0 in months.

I have a report which counts values on a table in which it is grouped by a value on that table and I want to count specific ranges with in that table and show the numbers on the report. My instructor told me to use =Select count (select * from [table] where [req]=Yes and [comp]=0 and...

My programming instructor told me to use this for counting records in a report with multiple conditions; =Select count (select * from [table] where [req]=Yes and [comp]=0 and ((Now()-[arrivaldate])/30.4)>=0 and ((Now()-[arrivaldate])/30.4)<=4 and [status]="UNQAL") But when I enter it, I get...