Minddumps
Registered User.
- Local time
- Today, 19:26
- Joined
- Jul 5, 2011
- Messages
- 73
I've created a query with intentions to only allow a record to show if it has a null value in any (or more than one) of 6 fields.
I tried intering 'Is Null' in the or section of the query's design view, but I didn't receive the results I was looking for... does anyone know how to do this?
It might help to describe my ending product (on this section):
I have an excel sheet that I mark which fields are missing. In it I have entered the number of missing information there is for each group of records that I have:
All of the red cells are the count of null values within that record group.
So when I finally get the query working correctly and input into a report, I want to then count each field by each group, but only count the null values just like the example above... anyone know the code for returning the count of only the null values?
I tried intering 'Is Null' in the or section of the query's design view, but I didn't receive the results I was looking for... does anyone know how to do this?
It might help to describe my ending product (on this section):
I have an excel sheet that I mark which fields are missing. In it I have entered the number of missing information there is for each group of records that I have:
All of the red cells are the count of null values within that record group.
So when I finally get the query working correctly and input into a report, I want to then count each field by each group, but only count the null values just like the example above... anyone know the code for returning the count of only the null values?
Last edited: