Filtering Specific Data

[bdhtexas]

Query - filtering out specific data

I have created a query that contains information received within the 4th qtr of 2003. However, I also need to filter out specific data from another field.

Example: under the received date I have the criteria set as:
Between #10/1/03# and #12/31/03#

Under the CatCode code, I also need to omit "DCR"
So I entered Not "DCR" in the Criteria

But under the Error code field, I also need 5 specific error types to NOT BE DISPLAYED in my query.

When I typed the following on the criteria line under the error code field or the or line, it did not work.
Not "CANCELLED" or Not "LTR" or Not "Purged" or Not "Returned" or Not "Review".

I know I can run several queries to get my answer, but I was wondering if there was a quick fix.

Thanks,
Brian

 

[WayneRyan]

Brian,

Not In ("Review", "Purged", ...)

Wayne

 

[bdhtexas]

Brian,

Not In ("Review", "Purged", ...)

Wayne

Thanks, it's working perfectly now.