simple query OR between fields

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

 

[Allen Browne]

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

 

[christopheguth]

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.

 

[??]

?