Simple Query Help - from a novice

[Nick]

Hi,
I have a simple query running on a large table.
One of my fields is called "AppType" and contains records like "A",
"B", "C", "CA", "CB"...etc.

I need to make a query that lists all of these records but excludes
specific fields, for example:
Run Query IF "APPTYPE" Is Not Equal to "CA" AND Is Not Equal to "FP"
AND Is Not Equal to "VC" etc. etc. but lots of them...

Can this be done?
Any help is greatly appreciated

regards

Nick

 

[Al Camp]

Nick,
Try a criteria of...
Not In("CA","FP","VC" ...etc)

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
There are 10 types of people in the world.
Those who understand binary, and those who don't.

 

[Nick]

Worked like a charm...
thanks for your help.

regards

Nick