Please help a new user out...

  • Thread starter Thread starter Krazy4mytt
  • Start date Start date
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.
 
make a query with a criteria, for that field:

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




Vanderghast, Access MVP
 
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
 
Note that John's answer is preferable if your field holds null values.


Vanderghast, Access MVP
 
Back
Top