Blank Columns in Xtab

[dtoney]

When running a crosstab query I've noticed when there is no data for a
period, the column will not show up unless the dates are specified. Is there
a way to get around this? Our raw data is shown by fiscal week but I need to
show each week to avoid gaps in reporting.

Any ideas?

 

[Duane Hookom]

I would create columns with "relative" weeks rather than date values. You can
try create column headings with an expression like:
"W" & DateDiff("w",[YourDateField],Date())
Then set your column headings property to display the last 6 weeks:
Column Headings: ""W0","W1","W2","W3","W4","W5"