Excluding Data

  • Thread starter Thread starter Amy Johnson
  • Start date Start date
A

Amy Johnson

Hi

Is there a way to exclude data from a query? What I need
to do is to exclude several office ID's from my query. I
know how to look for certain info by using the critera
field but dont know how to tell it to exclude. Any help
would be great.

Thanks
 
Am

In the Criteria field use the expression: Not In ("Not Wanted", "Also Not Wanted","Etc"

Regard
Rowan
 
Hi

Is there a way to exclude data from a query? What I need
to do is to exclude several office ID's from my query. I
know how to look for certain info by using the critera
field but dont know how to tell it to exclude. Any help
would be great.

Thanks
Click to expand...

Try a criterion on the OfficeID of

NOT IN(312, 448, 551)

or whatever the excluded ID's are.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query criteria - exclude data and return all records if null 3
Access Remove rows based on multiple fields 2
Multiple "Not Like" not working 5
Exclude items in a query 2
Excluding empty fields 4
Data mismatch error 2
Exclude query data 2
Exclude data from field, when another field equals a certain numbe 2

Back
Top