Date Ordered with Date Received Query

[Guest]

Hello,

I am trying to create a query for the following reasons:

Once an order has been placed, user enters date it was placed. Query used
to pull orders that are over 14 days old using date criteria: <Date()-14 and
another for 30 days. There is another field in the input form created for
the date when an order has been received.

What criteria do I use in the query so that when the order is received and a
date is entered that it no longer pulls the order information for outstanding
orders?

I'm not sure how to go about this.

Thank you.

 

[Jeff L]

In the criteria of the Date Received, put Is Null.

Hope that helps!