simple query OR between fields

  • Thread starter Thread starter Luke
  • Start date Start date
L

Luke

Another stupid question.

I have 5 fields in the same table. Field A,B,C,D,E,F

I want to create a query, to retrieve records where Field A (yes) OR
Field B (yes) . Field A and B are yes/no.

How do I do it using the simplest method?

Thanks.
 
In query design view, below the Criteria row are several rows marked Or.
Place your criteria on different rows, so it looks like this:
Yes
Yes
Yes
Yes
Yes

The real problem here is the way the table is designed. If you want to build
a relational design that can do more, see:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html
 
Luke said:
Another stupid question.

I have 5 fields in the same table. Field A,B,C,D,E,F

I want to create a query, to retrieve records where Field A (yes) OR
Field B (yes) . Field A and B are yes/no.

How do I do it using the simplest method?

Thanks.
Click to expand...
 
Back
Top