Querys

[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 statement 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?

 

[Alc]

Replace your "Or" parts with "And".

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

In your case, every time Lasalle or Montreal come up, the " <> Verdun" part is true and so the other two names will appear.

 

[sandrao]

Thanks Works just great

 

[Alc]

No problem.
Thanks for letting me know it works.