Multi column report Access 2002

  • Thread starter Thread starter Stephen Wood
  • Start date Start date
S

Stephen Wood

I am a newbie. I need to produce a report where weekly
amounts of sales are shown(ie. 52 columns, starting
1/4/04). All dates of sale are in a single field in my
table. I have 34 different sales branches. Could somebody
give me some advice on setting up the query/report?
Breakdown on report would be Grouped by branch, sales per
week. TIA
 
Sounds like a good place for a crosstab query. Your Column Heading would be
based on the expression:
ColHead: "Wk" & Format([DateField],"ww",0,3)
The "3" in the Format() sets the counting to start on the first full week.
If you don't use this option, then 12/31/2004 would be in the 53 week.

Then, set the column headings property to:
"Wk1", "Wk2","Wk3",..."Wk52"
 
Back
Top