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

  • Thread starter Thread starter paul.hoyle
  • Start date Start date
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
 
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 ...
 
Back
Top