leave out certain data in a query..

[stephendeloach via AccessMonster.com]

I have a query that pulls all of the Invoice #'s but I dont want it to pull
Invoice # 1, 6651, and 2. How can I exclude these from the query? Thanks.

 

[fredg]

I have a query that pulls all of the Invoice #'s but I dont want it to pull
Invoice # 1, 6651, and 2. How can I exclude these from the query? Thanks.

As Criteria on the Invoice# column, write

(If the Invoice# field is a Number datatype):
Not In (1,2,6651)

(If the Invoice# field is a Text datatype):
Not In ("1","2","6651")

 

[Guest]

in Invoice field, set the criteria= Not 6651