how do i set multiple criteria in a query

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?
 
J

John Vinson

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]
 

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

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

Top