Simple query?

[Aaron]

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.

 

[Frank Zart]

Hi Aaron, in your query design, put Yes into the Criteria row for columns A
and B.

Frank

 

[George Hepworth]

Select YourField
FROM YourTable
WHERE FieldA= True or FieldB = True

 

[Frank Zart]

Thanks Steve, that's right. I will read more closely in future before
putting fingers to keyboard.