Criteria Question

R

Ron A.

I have a query that when ran shows training due within the next 2 months. I
would also like to include any records that the due date is blank as well as
due within the next 2 months. How would I add this to the criteria I already
have? Existing criteria is as follows:

<Date()+60
 
F

fredg

I have a query that when ran shows training due within the next 2 months. I
would also like to include any records that the due date is blank as well as
due within the next 2 months. How would I add this to the criteria I already
have? Existing criteria is as follows:

<Date()+60
Click to expand...

As criteria on the Date field in the query, write on the line below
the current criteria:
Is Null
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

This is killing me! 2
query filter for end of current month 3
Query for 1st field, if blank then query 2nd field but not both. 6
Using 3 criteria to filter a report????? 2
QUERY CALCULATION BASED ON DATE RANGE? 4
IIF Expression with Between Dates criteria 7
excluding dates 3
Use In() Expression as Query criteria with guts from Function 1

Top