Question about Query criteria

S

Suzy

Hi,
I have records in a query that I need to filter. the first several columns
are basic vendor data, like name phone number etc, key is there unique
number. but the last 5 columns are either yes or no, how do I fliter to show
those records that have at least one yes (or more) in the last 5 columns? I
know I can filter the ones that have all no's by setting the Not "Yes"
criteria. thank you.

Suzy
 
J

Jeff Boyce

(actually, I'd hoped to discourage you from leaving the data in a
'spreadsheet' layout!)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Excel file into Word Document 3
Query to select individual records 4
query to show where no data in a stated column 0
QBF & Query Malfunction 0
Multiple Parameter Crosstab query filter by form 1
Query criteria from a previous query 2
Query the same table three times 0
Count in a Query 2

Top