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!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple-criteria query

Status
Not open for further replies.

Minuet

Technical User
Dec 18, 2002
48
CA
When creating a query, how can I search for more than two values at a time? I am wanting to search for three different values in the same field in one query.
 
HI Minuet,

You would enter this under the Criteria section in the query for the field that you want to search for the specified values. For example if you have a First Name list and only want to find people with the names of Bart, Joe, Mary then in the Criteria field you would enter ="Bart" Or "Joe" Or "Mary"

Let me know if this helps.

Regards,
gkprogrammer
 
That is just too easy! Can you tell I am new at this? :) Thanks very much, gkprogrammer!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top