Excluding Data

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
 
R

Rowan

Am

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

Regard
Rowan
 
J

John Vinson

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