retrieve records for "and" and "or" scenerios

J

John C.

I need a query that will retrieve records if 'r' appears in any one of two
fields. If field #1 has 'r' and field #2 does not, I want to return that
record.
Also if field #2 has 'r' and field #1 does not, I want to return that record
as well as if both field have a 'r'. Any ideas?
 
O

OfficeDev18 via AccessMonster.com

John,

Ignore the 'and', since 'or' will work. Hence,

WHERE (Field1 = "r") or (Field2 = "r")

Hope this helps,

Sam
 
Top