retrieve records for "and" and "or" scenerios

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
John,

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

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

Hope this helps,

Sam
 
Back
Top