Criteria Question

  • Thread starter Thread starter Ron A.
  • Start date Start date
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
 
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
 
Back
Top