"Add" Can I display numeric zero values in crosstab query reports?

I an using this SQL but I am not getting "0's" in month headers.RANSFORM
(NZ(Count(licensetcount.AcctionId),0)) AS CountOfAcctionId
SELECT licensetcount.PosDlicense, Count(licensetcount.AcctionId) AS [Total
Of AcctionId]
FROM licensetcount RIGHT JOIN Employees ON licensetcount.SSI = Employees.SSI
WHERE (((licensetcount.PosDlicense)=Yes))
GROUP BY licensetcount.PosDlicense, licensetcount.PosDlicense
PIVOT Format([ActionDate],"mmm") In
("Nov","Dec","Jan","Feb","Mar","Apr","May","Jun"," Jul","Aug","Sep","Oct");

Whan am I missing, Thanks in advance

Try:

TRANSFORM Count(Nz(licensetcount.AcctionId,0)) AS CountOfAcctionId
SELECT licensetcount.PosDlicense, Count(licensetcount.AcctionId) AS [Total
Of AcctionId]
FROM licensetcount RIGHT JOIN Employees ON licensetcount.SSI = Employees.SSI
WHERE (((licensetcount.PosDlicense)=Yes))
GROUP BY licensetcount.PosDlicense, licensetcount.PosDlicense
PIVOT Format([ActionDate],"mmm") In
("Nov","Dec","Jan","Feb","Mar","Apr","May","Jun"," Jul","Aug","Sep","Oct");

--
Duane Hookom
Microsoft Access MVP


"Nick" wrote:

I an using this SQL but I am not getting "0's" in month headers.RANSFORM
(NZ(Count(licensetcount.AcctionId),0)) AS CountOfAcctionId
SELECT licensetcount.PosDlicense, Count(licensetcount.AcctionId) AS [Total
Of AcctionId]
FROM licensetcount RIGHT JOIN Employees ON licensetcount.SSI = Employees.SSI
WHERE (((licensetcount.PosDlicense)=Yes))
GROUP BY licensetcount.PosDlicense, licensetcount.PosDlicense
PIVOT Format([ActionDate],"mmm") In
("Nov","Dec","Jan","Feb","Mar","Apr","May","Jun"," Jul","Aug","Sep","Oct");

Whan am I missing, Thanks in advance