Simple Query Help - from a novice

  • Thread starter Thread starter Nick
  • Start date Start date
N

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
 
Back
Top