Query

[Chey]

I have a query with the following fields
Service Date
Hotel Amount
Credit Card Amount
TA Number
Full Name
Right now I have Service date----Is not null in the critiera
How do I set the critera for Hotel Amount and Credit Card Amount. If both
of these do not have an amount then I don't want them to show?
Thanks
Chey

 

[Allen Browne]

Below the Criteria row in query design is a series of rows labelled Or. You
want to exclude the records where both fields are null, and also any records
where Service Date is null.

Your criteria will therefore look like this:

[Service Date] [Hotel Amount] [Credit Card Amount]

Is Not Null Is Not Null
Is Not Null Is Not
Null