S
shannaj via AccessMonster.com
I am trying to set my null values to zero with the nz function in my query
for monthly sales totals, but I can not figure how to use it. Here is my SQL,
can someone please help?
TRANSFORM Sum(qryCustomerSales2006.Amount) AS SumOfAmount
SELECT qryCustomerSales2006.[Customer ID], Sum(qryCustomerSales2006.Amount)
AS [Total Of Amount]
FROM qryCustomerSales2006 LEFT JOIN tblCustomerList ON qryCustomerSales2006.
[Customer ID] = tblCustomerList.[Customer ID]
GROUP BY qryCustomerSales2006.[Customer ID]
PIVOT Format([Date],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul",
"Aug","Sep","Oct","Nov","Dec");
for monthly sales totals, but I can not figure how to use it. Here is my SQL,
can someone please help?
TRANSFORM Sum(qryCustomerSales2006.Amount) AS SumOfAmount
SELECT qryCustomerSales2006.[Customer ID], Sum(qryCustomerSales2006.Amount)
AS [Total Of Amount]
FROM qryCustomerSales2006 LEFT JOIN tblCustomerList ON qryCustomerSales2006.
[Customer ID] = tblCustomerList.[Customer ID]
GROUP BY qryCustomerSales2006.[Customer ID]
PIVOT Format([Date],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul",
"Aug","Sep","Oct","Nov","Dec");