Counting the number of records where a certain field is empty.

[the-m0th]

Hi everyone,

I have a table of data that has a column called FO and a column called Group within it. I'm trying to figure out how many records have a blank FO field and group them by the group field.

so far this is what i've got and all it's doing is listing all the groups from the Group field with a zero value next to them.


any help anyone can give me will be greatly appreciated.

thanks
Wayne

 

[CJ_London]

what datatype is FO? your post implies number, your query implies text

number fields can only be null or a number (including 0), they cannot be ""

In addition Group is a reserved word - using it can cause unexpected problems so suggest change your field name to something else.

count of a field does not count null values so change the FO for this column to *

 

[the-m0th]

The FO Column is a text field. I've found a solution online which also uses the *. thanks for the info on Group being a reserved word, I'm still drowning in this access malarkey after being thrown in the deep end a year ago and things like that are great to know. the solution i found was an SQL query...

SELECT Count(*) AS CountOfValues, zWayne.Group
FROM zWayne
WHERE (((zWayne.[FO]) Is Null))
GROUP BY zWayne.Group;

thanks again!