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.

because X is a result of doing the datediff(expr) function on a record in a report. the datediff() changes in every record. My results are 0-24 across all records, I am just trying to populate a text box with a number on a report.

I changed it from "four" to "several" a few seconds after I posted it. I didnt realize I had origionally posted four and then added the rest.

i have datediff("m", [arrivaldate], date())=x values I am getting for the first several records are 1,7,14,8,2,1,4 when I am evaluating if x<2 and x>0 I am getting false for ALL RECORDS.

What do you want to see? I am at work finally. Thats why I posted that code a few posts ago. I didnt have it for the first 4 because I hadn't left yet. Is there a way to convert an integer in the code to a date using some sort of wrapped command? For instance, if I wanted to make something...

I didnt have the exact code till i got to work. The exact details of my entire line are irrelevant. I was just posting it to show you what I was doing and where it was breaking to validate my point. The problem isnt with the syntax, the syntax works. The conversion of the datediff() is picking...

I was just using the now() equation as an example. Datediff(), now() and date() all return the same result of false when datediff("m", [tabledate], date())=1. The equation I am using is DCount("*","1-Primary Table","[phaseonereq]=Yes and [phaseonecomp]=0 and datediff('m', [arrivaldate]...

Done, no go. Still is returning a weird result.

but if you datediff("m", [tabledate], date()) in a query, you get a range of dates depending on which value of [tabledate] is being evaluated. I've plugged it into a query, I can clearly see the result it 1 but it is failing a logical evaluation even when I evaluate the query without all the...

actually the expr in the parenthesis are exactly the same. I am just evaluating [date ranges] out of tables vs. the current date to get records within my current criteria. its something along the lines of =dcount(*, 'tablename', criteria1 and criteria2 and criteria3 and datediff(expr)>X and...

a number cant be both less than 0 and greater than 2 but a result can be both. plus, the result can be a range of numbers, the key is I am attempting to evaluate one table against multiple logical tests to get records that meet my criteria. the only part that doesnt work is this datediff()...

I am well aware, I was short handing it cause the info between the parenthesis doesnt appear to matter. I had it set to "m" and "d" and neither worked.

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?

how do you make datediff() that =1 be >0 and <2? Apparently there is some conversion issues with this formula.

Yes I am definately having an issue with the datediff() command. I rewrote the command as an IIF(IIF(IIF))) statement and put it into a query and moved the falses around. I managed to find out that dispite the face datediff(expr)=1 that it is not >=0 and <2.

This syntax "works", it just doesnt return anything =IIf([AFSC]="2A5X1","N/A",DCount("*","1-Primary Table","[phaseonereq]=Yes and [phaseonecomp]=null and datediff('m', [arrivaldate], date())>=2 and datediff('m', [arrivaldate], date())<4 and [phaseonestatus]='UNQAL'"))

I'm specifically trying to get the time between two dates.

This helped me immensely as well. Thank you for your assistance.

problem with datediff() is apparently it doesnt give me the proper syntax when imbedded in a control source in a form and it doesnt do decimals. =IIf([AFSC]="2A5X1","N/A",DCount("*","1-Primary Table","[phaseonereq]=Yes and [phaseonecomp]=null and ((Now()-[arrivaldate])/30.4)>=0 and...

=IIf([afsc]="2a5x1", "N/A", 'I want the box to report "N/A" when the grouping is "2a5x1" DCount("*","1-Primary Table", 'table I am counting records on is "1-Primary Table" "[phaseonereq]=Yes 'I have lots of conditions to each record counting and [phaseonecomp]=0 and...