I need a xtab query to show zero months.

[Frank Martin]

I have Access2003

I want to show sales of products per month
in a xtab query, but I need the non-sale
months to be shown as a zero too.

Please help, Frank

 

[KARL DEWEY]

Add an IN statement in your PIVIOT statement like this ---
PIVOT Format([YourDateField],"mmm") In ("Jan","Feb","Mar","Apr","May",
"Jun","Jul","Aug","Sep","Oct","Nov","Dec");