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

[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

 

[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 ...