I need a xtab query to show zero months.

F

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
 
K

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");
 
Top