count blank colums in crosstab query

[survivo01]

I have a crosstab query I want to count the blanks for each class name
In other words is there a way to create a column for the blanks or do I need to fill the blanks with something to count. For example under column ABE1 the blank squares means 4 people have not been enrolled in that class. In column cog1 there are three blank squares meaning five people have not enrolled in tha t class. I need the sum of blanks for each column

personID	Total Of enrolltype	ABE1	cog1	cult1
1	4	1	1
2	4	1		1
3	1
4	2	1
5	1		1
6	1			1
7	1

[June7]

I see 5 blanks each under cog1 and cult1.

Try:
SELECT Sum(IIf(IsNull([abe1]),1,0)) AS BlankABE, Sum(IIf(IsNull([cog1]),1,0)) AS BlankCOG, Sum(IIf(IsNull([cult1]),1,0)) AS BlankCULT
FROM Table1_Crosstab;

[survivo01]

I don't know how to do what you suggest.

[June7]

Build a query with query designer using the crosstab as the data source and create fields with the expressions or copy/paste the sql I suggest into the SQL View editor of the query designer. Use your crosstab query name in place of Table1_Crosstab.

[survivo01]

Sum(IIf(IsNull([Adult Basic Education AM]),1,0)) AS BlankAdult Basic Education AM
Here is what I entered and I get message you have entered and operand without an operator

[June7]

If spaces, special characters, or punctuation (underscore is exception) are used in names or reserved words as names, must enclose in []:
AS [BlankAdult Basic Education AM]

[survivo01]

I must be not very bright.
Sum(IIf(IsNull([Adult Basic Education AM]),1,0)) AS [BlankAdult Basic Education AM]
Still same message and highlights the word AS