Report with columns

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

Access 2000

My query has the following fields:
Year (Ex:2000)
WDay (Weekday Ex: Monday)
CountOfCrtID (Ex: 254)

I need my report to display as follows:

2000 2001 2003
Sunday 145 188 192
Monday 140 145 182
Tuesday 165 155 188
Wednesday etc...
Thursday
Friday
Saturday

Should this be done with a crosstab and if so can someone
get me started?

I haven't worked with crosstabs.

Any and All Help Always Appreciated!
Dale
 
This could be done with a crosstab. Start with a standard select query and
change it to a crosstab. Set the Year as Column Heading, WDay as Row
Heading, and Sum(CountOfCrtID) as the value.
 
Back
Top