multiple filter criteria on same field (1 Viewer)

rodrigoturbina

Registered User.
Local time
Today, 07:12
Joined
Jul 30, 2014
Messages
29
Hi everyone this is Rod, I am using MS Access 2007.

I would like to display a report based on the table called "expenses", filtered by:
- "from" (datefrom field) and "to" (dateto field) date on "payment date" field;
- multiple criteria on same field called "payment method" (I would like to include only payment methods "check" and "credit card", but not the other payment methods in the field, such as "cash", "transfer", etc.)

For that end I made a query based on the table "expenses", and in the "payment date", in the criteria field, I entered:

between [form]![formname]![datefrom] and [form]![formname]![dateto]

This works fine so far, however when I attempt to add multiple criteria on the "payment method" field, it does not filter accurately any longer. In the same row of the criteria field where I completed the date criteria, I enter "check". In the next row, same field, I enter "credit card".

Since it doesn´t work, I tried putting both arguments in the same line as the date criteria (always in the payment method field) as: "check" and "credit card" but still does not work (now it filters the payment method correctly, but the dates filter appear as if I have never completed them).

Hope you can provide some help here :)
Thanks in advance
Rod
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 03:12
Joined
Aug 30, 2003
Messages
36,118
In the same line as the date criteria try

In("check", "credit card")
 

rodrigoturbina

Registered User.
Local time
Today, 07:12
Joined
Jul 30, 2014
Messages
29
That worked! thanks so much for the prompt response, Paul :)
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 03:12
Joined
Aug 30, 2003
Messages
36,118
Happy to help Rod!
 

Users who are viewing this thread

Top Bottom