Question about Query criteria

  • Thread starter Thread starter Suzy
  • Start date Start date
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
 
(actually, I'd hoped to discourage you from leaving the data in a
'spreadsheet' layout!)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top