Dreamweaver
Well-known member
- Local time
- Today, 14:51
- Joined
- Nov 28, 2005
- Messages
- 2,466
I have build a number of crossbab queries.
one a last 12 month units sold which is not the problem
my problem is a weekly crosstab as in image I need to enbend it into a report and form but the column heads will chenge depening on the week
I.E. Wk19 - Wk31 what I need is for it to allways show Wk1 - Wk12 I've tried everything I can think of without luck, I haven't built a lot of crosstabs so decided to add a number to the example I'm working on this being the first with a problem.
one a last 12 month units sold which is not the problem
my problem is a weekly crosstab as in image I need to enbend it into a report and form but the column heads will chenge depening on the week
I.E. Wk19 - Wk31 what I need is for it to allways show Wk1 - Wk12 I've tried everything I can think of without luck, I haven't built a lot of crosstabs so decided to add a number to the example I'm working on this being the first with a problem.