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

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

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");
 
Back
Top