Expression Builder

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

Guest

I have a querie with many different states. I need to have it exclude two of
the states in the querie IE: AZ and MI.
 
In the critera row for your State column in the query builder, put this:
NOT IN("AZ", "MI")
 
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 do I use checkboxes in an Access form to get query results? 1
I can't open expression builder 5
Table Names not showing in Expression Builder 6
Excel VBA 1
calculating columns (fields) 2
Expression Builder 7
Query of Expired Docs 3
returning current month and year 2

Back
Top