Please help a new user out...

K

Krazy4mytt

I have a field titled Decision. There are serveral options writting under
decision. How do I run a query where everything but "TBD" , "In-Progress",
and "Pass" will print? THANKS.
 
M

Michel Walsh

make a query with a criteria, for that field:

NOT IN ("TDB", "In-Progress", "Pass" )




Vanderghast, Access MVP
 
J

John Spencer

FIELD: Decision
CRITERIA: NOT IN ("TBD","In-Progress","Pass") Or Is Null

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
M

Michel Walsh

Note that John's answer is preferable if your field holds null values.


Vanderghast, Access MVP
 
Top