How to get a listing that includes 3 yes/no answers 1

[twyka]

I have a table that has many entries that have yes/no answers. I would like to make a report that shows the products that have a yes in any of the three boxes. I only seem to be able to get an exclusive list, where it shows only the products with all three yeses.

I am a basic user, I have consulted my manuals but can't find a simple answer.

Thanking anyone for any help they might provide.

 

[GingerR]

In your query you'll see that there are multiple rows below the query grid where you can put criteria. put TRUE on three different rows:

Check1 Check2 Check3
True
True
True

This will then read "If Check1 is True OR Check2 is True OR Check3 is True"

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[twyka]

Absolutley Fantastic, that was so helpful, it worked like a charm!!!!

Thank you so much!!!