Show records if one date is greater than the other

[heynay01]

I have 2 tables I'm comparing in a query, each has a date field -QCDate in tbl1 and ReviewDate in tbl2. I need the query to only return records where the QCDate =< ReviewDate. How in the heck do I do this? I can't figure it out for the life of me.



Thank you!

[Bob Fitz]

Hi

You may like to try this:

Put "=< ReviewDate" (without the quotes) in the WHERE line of the query, under "QCDate"

[boblarson]

You also need to change it to

<= [ReviewDate]

as =< is incorrect syntax and will give you an error.

[heynay01]

FYI - syntax was just my typo in here.

I tried <=ReviewDate before (and again just now) and I keep getting a pop-up message saying "Data type mismatch in criteria expression." Any ideas?

[boblarson]

FYI - syntax was just my typo in here.

I tried <=ReviewDate before (and again just now) and I keep getting a pop-up message saying "Data type mismatch in criteria expression." Any ideas?

You need to include the square brackets around ReviewDate so it knows you are talking about the FIELD.

<=[ReviewDate]

as I showed. Otherwise, if that doesn't work then you need to check to make sure that they are both really date/time fields.

[heynay01]

Thank you! The problems was one of the fields was text - that table was made by another user so I never even thought of checking for that. Worked like a charm once I changed it