Limit Query returns

[zogpound]

I'm try to limit my returns in a query. It's a customer list that I want to return all states except 5. If I use the "not" and the state abbreviation in the critera field it works fine for one state. When I add the other states only the first listing is left our.

Not "PA" works fine
Not "PA" or "OH" or "KY" etc...still only pulls the "PA" info out.

Thanks, Eric

 

[antomack]

The following should work

Not "PA" and not "OH" and not "KY" .....