I am using a simple crosstab query in Access 2013 showing a sales region with the sales amount in each category. On any given day they may or maybe sale a certain item. I would like my query to still show the sales category but with a $0.00 or even a blank.
In my screenshots on Monday they sold bananas and strawberries so it of course shows them. On Tuesday they did not sales bananas or strawberries but I would like to still see the column headers that say 'bananas' 'strawberries'.
Can this be done?
TRANSFORM Sum(dds_Daily_MOP_Tb.MOP_Amount) AS SumOfMOP_Amount
FROM store INNER JOIN (mop INNER JOIN dds_Daily_MOP_Tb ON mop.mop = dds_Daily_MOP_Tb.MOP) ON store.STORE = dds_Daily_MOP_Tb.Store_Number
GROUP BY store.region