to NOT show

T

Tammy

Hey there smart people!

I have a table of customers; there are certain customers I no longer want to
mail too; so in my labels query, how do I tell it I want to NOT show
CustomerID 350, 407, 405, 421, etc, etc.
 
K

KARL DEWEY

The best way, as the list will continue to grow, is to add a flag field named
something like Inactive/Old/Archive as a Yes/No field. Then in your queries
use criteria on that field of 0 (zero) to show all active/now customers. To
show only inactive/old use -1 (minus one) and for all use no criteria.
 
J

John W. Vinson

Hey there smart people!

I have a table of customers; there are certain customers I no longer want to
mail too; so in my labels query, how do I tell it I want to NOT show
CustomerID 350, 407, 405, 421, etc, etc.
Click to expand...

Karl's suggestion is a good one - having a list of meaningless ID's buried in
a query somewhere will become a maintenance headache! But if you want the
headache anyway, you can use a criterion

NOT IN(350, 407, 405, 421)
 
Top