I have a cross tab query with the codes below:
TRANSFORM Sum(OrdersDetail.Quantity) AS SumOfQuantity
SELECT OrdersDetail.[Product Name]
FROM OrdersDetail
GROUP BY OrdersDetail.[Product Name]
PIVOT OrdersDetail.Sold;
Since some product never been sold, that's why it shows blank. What codes need to be added in order to display those blank field to "0."
Thanks,
TRANSFORM Sum(OrdersDetail.Quantity) AS SumOfQuantity
SELECT OrdersDetail.[Product Name]
FROM OrdersDetail
GROUP BY OrdersDetail.[Product Name]
PIVOT OrdersDetail.Sold;
Since some product never been sold, that's why it shows blank. What codes need to be added in order to display those blank field to "0."
Thanks,