Yes,Yes,Yes,Yes,Yes,Yes! in a query

P

paul.hoyle

I have a query that returns a number of fields - 6 of these fields could
display the word "Yes" - how do I only show records that have 1 or more of
these fields that display "Yes"?

Thanks in advance
 
S

Steve Schapel

Paul

If you are using the design view of the query, enter "Yes" in the
criteria of each of the 6 columns, each in a different row of the query
design grid. The SQL view of the query will be structured something
like this:
SELECT .... FROM ....
WHERE [1stField]="Yes" Or [2ndField]="Yes" Or [3rdField]="Yes" Or
[4thField]="Yes" Or ...
 
Top