Select on two fields

T

tenbob

I want to create a query that selects from a parameter in either of two
fields. That is all that are "A" in one field OR "B" in the second.
 
R

Rick Brandt

tenbob said:
I want to create a query that selects from a parameter in either of two
fields. That is all that are "A" in one field OR "B" in the second.
Click to expand...

SELECT * FROM SomeTable
WHERE SomeField = "A"
Or SomeOtherField = "B"

In the query design grid just make sure the two criteria are on separate
rows which produces an OR whereas having them on the same row produces an
AND criteria.
 
Top