Show empty months in pivot chart

[Guest]

Hi,

I have an access 2003 pivot chart that shows sales for the past year by
months.

The number of sales is calculated by the count of the date of sale.

If there are no sales in a specific month, that month does not appear in the
chart.

How can I ensure that all months are shown in the pivot chart even if there
are no sales in some months?

Thanks, Sean.

 

[Guest]

Try adding this to your SQL statement --
PIVOT Format([SalesDate],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");