Not include certain data

  • Thread starter Thread starter Alicia
  • Start date Start date
A

Alicia

I have built a db with data for the entire country. In my
query, I'm pulling information & sorting it by state.
There are a handful of states that I do not want to see.
What can I type in the criteria so the query will run but
not show anything for, say Virginia & Washington but will
show me data for all the rest?

Thanks!
 
not "virginia" and not "washington"



Rick B

I have built a db with data for the entire country. In my
query, I'm pulling information & sorting it by state.
There are a handful of states that I do not want to see.
What can I type in the criteria so the query will run but
not show anything for, say Virginia & Washington but will
show me data for all the rest?

Thanks!
 

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 Parameter Syntax 2
Access Access Report Works on One Machine but not Another 3
Don't show null columns 5
Iff & Not Equal to criteria 5
Combine Duplicates in Query 0
Multiple Criteria in a query 9
Access Dcount (multiple criteria) 3
simple query no data found 1

Back
Top