Loosing fields when creating a crosstab from a table

[Bryan McDonald]

I am trying to create a crosstab query off oa a table which contains Build
Units by Product Type, by Week, by Location. However when I run the
crosstab, I lose any of the weeks for which there were know build units. I
need to keep these weeks or a place holder so that I can populate with an
average build qty.

 

[Allen Browne]

Use the Column Headings property of the query to list all the column
headings, even if they don't have data.

More info:
http://allenbrowne.com/ser-67.html#ColHead