Can't get the count if fiedl is Null

[Thompyt]

I have three fields that Votes="Defer" and Final_Vote is Null. Votes field is correct.

TRANSFORM Nz(Count([CR_ID])-1,0) AS CR_IDs
SELECT Chng_ReqQry.Level, Nz(Count([CR_ID])-5,0) AS [HB Totals]
FROM Chng_ReqQry
WHERE (((Chng_ReqQry.Sub_No)=0) AND ((Chng_ReqQry.Date_Closed) Between Now() And Date()-7))
GROUP BY Chng_ReqQry.Level
PIVOT IIf(Not IsNull([Final_Vote]),[Final_Vote],(IIf(Not IsNull([GO_Vote]),[GO_Vote],(IIf(Not IsNull([O6_Vote]),[O6_Vote],[AO_Vote])))));

What am I missing that it will not count the 3 "Defer"? The count Header does not display <>, so I am assuming it is not counting where Final_Vote is null. Could it be that it is not counting that "Level"?

IIf(Not IsNull([Final_Vote]),[Final_Vote],(IIf(Not IsNull([GO_Vote]),[GO_Vote],(IIf(Not IsNull([O6_Vote]),[O6_Vote],[AO_Vote]))))) Gets me the Withdrawn count, recognizes Deferred, but not Defer

IIf(Not IsNull([GO_Vote]),[GO_Vote],(IIf(Not IsNull([O6_Vote]),[O6_Vote],[AO_Vote]))) Recognizes Defer and gets me the Defer count, but not the Withdraw count.

[Ruegen]

I have three fields that Votes="Defer" and Final_Vote is Null. Votes field is correct.

TRANSFORM Nz(Count([CR_ID])-1,0) AS CR_IDs
SELECT Chng_ReqQry.Level, Nz(Count([CR_ID])-5,0) AS [HB Totals]
FROM Chng_ReqQry
WHERE (((Chng_ReqQry.Sub_No)=0) AND ((Chng_ReqQry.Date_Closed) Between Now() And Date()-7))
GROUP BY Chng_ReqQry.Level
PIVOT IIf(Not IsNull([Final_Vote]),[Final_Vote],(IIf(Not IsNull([GO_Vote]),[GO_Vote],(IIf(Not IsNull([O6_Vote]),[O6_Vote],[AO_Vote])))));

What am I missing that it will not count the 3 "Defer"? The count Header does not display <>, so I am assuming it is not counting where Final_Vote is null. Could it be that it is not counting that "Level"?

replace the null values with a value of 0

I think you can do this using the nz() function

so in the query have nz([Field],0)

that way if it is null it will access to make the field with a value of 0 and then calculate.