Cross Tab that will give a 0 if is null

[KAnoe]

I'm doing a cross tab Q that I ned a 0 in if the feild is null.
GMA GFA
Sales Per 1 1
Sales Per 2 1
Sales Per 3

Here is the code that I get in SQL.

TRANSFORM Count([Low_Producer_DEP-In_Rpt].DEPinFY) AS [The Value]
SELECT [Low_Producer_DEP-In_Rpt].RC, [Low_Producer_DEP-In_Rpt].[RCTR Last
4], [Low_Producer_DEP-In_Rpt].RAUSAR,
Count([Low_Producer_DEP-In_Rpt].DEPinFY) AS [Total Of DEPinFY]
FROM [Low_Producer_DEP-In_Rpt]
GROUP BY [Low_Producer_DEP-In_Rpt].RC, [Low_Producer_DEP-In_Rpt].[RCTR Last
4], [Low_Producer_DEP-In_Rpt].RAUSAR
PIVOT [Low_Producer_DEP-In_Rpt].MissionCAT In
("CFA","CMA","GFA","GFB","GMA","GMB","SFA","SFB","SMA","SMB","HFA","HMA","CMB","CFB","PS","GM4","GM5","GF4","GF5","SM4","SF4","HMB","HFB","HM4","HF4","HM5","HF5","CM4","CF4","CM5","CF5","SM5","SF5","NMA","NFA","NMB","NFB","NM4","NF4","NM5","NF5");

 

[Duane Hookom]

TRANSFORM Val(Nz(Count([Low_Producer_DEP-In_Rpt].DEPinFY),0)) AS [The Value]