Access 2003 Query that won't accept No as a Criteria

langtryster · 10-28-2009, 10:54 AM

I am trying to create a query that will give me a count of pending complaints. Pending complaints would be all complaints that have not been resolved, deleted, transferred, or closed. When I indicate that the result should be grouped by Count with the Criteria "No" in order to get a count of all those fields (they are all yes/no boxes) where the box was not checked, with the Criteria No I do not get any results, although there are records with that information.

I tried the same query with the Criteria Yes, and it worked fine--why won't it work with No?

**djaburg** · 10-28-2009, 04:06 PM

the criteria should most likely be "is null" . I believe the field is either blank or yes when it's stored.

langtryster · 10-29-2009, 09:50 AM

Right you are. Unfortunaltely, Is Null and "Is Null" result in the same thing: the records in which the yes/no boxes are not checked are once again not being counted. Any other suggestions?

10-28-2009, 10:54 AM	#1 (permalink)
langtryster Registered User Join Date: Oct 2009 Posts: 2 OS: Windows XP	Access 2003 Query that won't accept No as a Criteria I am trying to create a query that will give me a count of pending complaints. Pending complaints would be all complaints that have not been resolved, deleted, transferred, or closed. When I indicate that the result should be grouped by Count with the Criteria "No" in order to get a count of all those fields (they are all yes/no boxes) where the box was not checked, with the Criteria No I do not get any results, although there are records with that information. I tried the same query with the Criteria Yes, and it worked fine--why won't it work with No?

10-28-2009, 04:06 PM	#2 (permalink)
djaburg TSF Enthusiast Join Date: May 2008 Posts: 1,321 OS: XP SP3/Vista/7 Server 2K/2K3/2K8	Re: Access 2003 Query that won't accept No as a Criteria the criteria should most likely be "is null" . I believe the field is either blank or yes when it's stored. __________________ Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done. The inherent vice of capitalism is the uneven division of blessings, while the inherent virtue of socialism is the equal division of misery.

10-29-2009, 09:50 AM	#3 (permalink)
langtryster Registered User Join Date: Oct 2009 Posts: 2 OS: Windows XP	Re: Access 2003 Query that won't accept No as a Criteria Right you are. Unfortunaltely, Is Null and "Is Null" result in the same thing: the records in which the yes/no boxes are not checked are once again not being counted. Any other suggestions?