how do i set multiple criteria in a query

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

Guest

I am trying to run a query to exclude 8 counties in the county field - can
only get it to exclude one. What am I doing wrong?
 
I am trying to run a query to exclude 8 counties in the county field - can
only get it to exclude one. What am I doing wrong?
Click to expand...

Try using the syntax

NOT IN("Ada", "Canyon", "Owyhee", "Payette", "Boise")

on the Criteria line.

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to do Multiple update in one query 3
Access Remove rows based on multiple fields 2
Exclude data from field, when another field equals a certain numbe 2
Query criteria - exclude data and return all records if null 3
Multiple "Not Like" not working 5
Data mismatch error 2
what is the criteria to look up more than 1 Value in a field 6
using field name as value in query 2

Back
Top