Query

[sandrao]

I have created a cbo box that I am using to selects locations (citys) in a
field. I have used "Distinct" to elimate the duplicates but I also want to
elimate three locations. They are Verdun, Lasalle, and Montreal. In my
query I have tried the following statements in the Critera location. Not
"Verdun" Or "Lasalle" Or "Montreal". The query returns the following
statement: <>"Verdun" Or "Lasalle" Or "Montreal" this statement does take out
the first location "Verdun" but the two others still remain in the field.
How do I solve this problem?

 

[John Spencer]

Try the following criteria

<>"Verdun" AND <> "Lasalle" AND <>"Montreal"

Or simpler to to understand and probably as efficient

NOT IN ("Verdun","Lasalle","Montreal")

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[sandrao]

Thanks, Just what I wanted

Try the following criteria

<>"Verdun" AND <> "Lasalle" AND <>"Montreal"

Or simpler to to understand and probably as efficient

NOT IN ("Verdun","Lasalle","Montreal")

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..