Query Criteria question

D

daniel

In a query; the fields are:
CustomerID, Customer, NotPaid, Overdue, Outstanding.
Where Notpaid is under 10 days, overdue is over 10 days, outstanding is over
30 days.
I need to see NotPaid and Overdue only.
If I type True in both Criterias, it shows nothing. I can only go with one
True.
How can I do it so I can see both but no other data which would be
irrelevant?
I know I can do one form NotPaid, the other Overdue, then show both pages.
I am trying to avoid that.
 
J

Jerry Whittle

You need an Or statement. In the query design view put the True for the two
fields on different lines on the Criteria.
 
D

daniel

Thank you so much. It works!
Henry

Jerry Whittle said:
You need an Or statement. In the query design view put the True for the
two
fields on different lines on the Criteria.
 
Top