how do i set multiple criteria in a query

R

rleves1012

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]
 
Top