 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2006retrieve records for "and" and "or" scenerios
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 >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?  SignatureSam |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.