New User - Filtering Out Query Data

  • Thread starter Thread starter Jeff Young
  • Start date Start date
J

Jeff Young

I have a query table that I want to filter out states for
the midwest. I have two fields that contain state names.
One if first stop point, second is final destination.
I want to filter out the second one so that only the
midwest states are printed in the query. The syntax I am
using is in the criteria of the query design
(destination) is <>"PA" AND <>"OR" etc. I have tried
using the syntax OR but that does not work either. Should
I be using parenthesis or brackets? Please help. Hot
project.
Thanks.
 
This all depends on the information that is stored in the destination field.

You have 2 ways either you say which destinations to include :

SELECT * FROM Table WHERE Destination="MidWest1" OR Destination="MidWest2"
OR Destination="MidWest2" OR ...

or You indicate which destinations you don't need

SELECT * FROM Table WHERE Destination<>"Other1" AND Destination<>"Other2"
AND Destination<>"Other3" AND ...

- Raoul
 
Back
Top