Recent content by Myysterio

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.