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.
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 Krazy4mytt wrote: > 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 "Krazy4mytt" wrote in message news:28FD8A0E-7FFA-4935-92B5-E2D61841F8E8@microsoft.com... >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.
Thanks so much Michel and John. This is exactly what I needed to do. "Michel Walsh" wrote: > make a query with a criteria, for that field: > > NOT IN ("TDB", "In-Progress", "Pass" ) > > > > > Vanderghast, Access MVP > > > "Krazy4mytt" wrote in message > news:28FD8A0E-7FFA-4935-92B5-E2D61841F8E8@microsoft.com... > >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. > > >
Note that John's answer is preferable if your field holds null values. Vanderghast, Access MVP "Krazy4mytt" wrote in message news:4FF00654-4FB7-4A59-8939-11C322FC8AFF@microsoft.com... > Thanks so much Michel and John. This is exactly what I needed to do. > > "Michel Walsh" wrote: > >> make a query with a criteria, for that field: >> >> NOT IN ("TDB", "In-Progress", "Pass" ) >> >> >> >> >> Vanderghast, Access MVP >> >> >> "Krazy4mytt" wrote in message >> news:28FD8A0E-7FFA-4935-92B5-E2D61841F8E8@microsoft.com... >> >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. >> >> >>
