how do you write a query that requires exclusion of more than one.

[Salli]

I have a database that has a field called places. I need a query that will
exclude 3 specific places of the data.

 

[Rick B]

Not "x" and Not "y" and Not "z"

 

[geebee]

hi,


....WHERE [fieldname] NOT IN("x","Y","Z").

hope this helps...
geebee