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