MSAccess Using Filters 1

bene · Jun 14, 2000

Is it possible to use multiple filters for retrieving records. Exapmle,can I use   "xxx and xxxx and xxxxx" and retrieve records with three differets values. If so how is it done. Thanks for any help. Ben

Guest_imported · Jun 14, 2000

xxx OR xxxx OR xxxxx

DougP · Jun 15, 2000

If you want to AND the items then its "xxxx" And "yyyy" And "zzzz" "Smith" And "Taylor" And "Resen" it must meet all three criteria to return a recordset the Or's have it, if it's "Either" "OR" "xxxx" Or "yyyy" Or "zzzz" "Smith" Or "Taylor" Or "Resen" It can be anyone of the three to return a recordset DougP <a href=mailto: dposton@universal1.com> dposton@universal1.com</a> <a href= > </a> Ask me how Bar-codes can help you be more productive.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

MSAccess Using Filters 1

bene

Technical User

Guest_imported

New member

DougP

MIS

Similar threads

Part and Inventory Search

Sponsor