leave out certain data in a query..

  • Thread starter stephendeloach via AccessMonster.com
  • Start date
S

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

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.
Click to expand...

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")
 
Top