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!
 
Back
Top