Detail in a single row

[rmuirhead/CSC/AUST]

Hi,

Is it possible to display the detail of a report in a single row, instead of
down the page across multiple rows?

I'm looking to generate something like this:

2006
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Position 1 0 10 25 10 10 5 10 2 50 50 60 100
Position 2 10 10 10 10 10 10 10 10 10 10 10 10
Position 3 15 1 10 20 30 40 50 60 75 80 100 10

Where the number of hours worked by each position is displayed across all
months for a particular year. The years would also be displayed in the same
row as well, so a similar table for 2007 would follow on the right.

Is there any way to do this? The default report wizard seems to give the
following:

Position 1
2006 Jan 0
2006 Feb 10
...
2006 Dec 100
Position 2
2006 Jan 10
2006 Feb 10
and so on...

Any help or advice would be much appreciated. I am using Access 2003.

Thank you for your time.

Ray Muirhead

 

[Duane Hookom]

You can use a crosstab query with a column heading expression of something
like:
ColHead: Format([WorkDate],"yyyy-mmm")
Then set the column headings property to:
"2006-Jan","2006-Feb",...
I prefer to set relative column headings that uses the
DateDiff("m",[DateField],[Some Date Expression])