Defaults in CrossTab query.

[haydenbl]

I have a very simple crosstab query.



TRANSFORM Count(QryWaiverWPlan.MEME_CK) AS CountOfMEME_CK
SELECT QryWaiverWPlan.SBAD_COUNTY, QryWaiverWPlan.UniqueSS, QryWaiverWPlan.[PD WL], QryWaiverWPlan.[ICF/MR], QryWaiverWPlan.[ICF/MR Visit], QryWaiverWPlan.[DD WL], QryWaiverWPlan.Capacity, Count(QryWaiverWPlan.MEME_CK) AS [Total Of MEME_CK]
FROM QryWaiverWPlan INNER JOIN Waivers ON QryWaiverWPlan.Wiaver_Population = Waivers.Wiaver_Population
WHERE (((Waivers.Capacity_Tool) Is Not Null))
GROUP BY QryWaiverWPlan.SBAD_COUNTY, QryWaiverWPlan.UniqueSS, QryWaiverWPlan.[PD WL], QryWaiverWPlan.[ICF/MR], QryWaiverWPlan.[ICF/MR Visit], QryWaiverWPlan.[DD WL], QryWaiverWPlan.Capacity
PIVOT Waivers.Capacity_Tool;

What I need is to have Count(QryWaiverWPlan.MEME_CK) have a default of zero. When I take this query into a report and try to do some calculations, I get errors "#Type!".

I have tried the Nz command and no luck, and I have tried using Val on the fields that I am calculating.
Any help is greatly appreciated.

[June7]

You tried the Nz where? Post the attempted expression.