Horizontal repetition

[branston]

Hey!

Really don't know if this is even possible, but hopefully someone out there will have a good idea that I wouldn't think of!!

OK, I have a table which has total hours against a group of about 10 names for each month.
I need a report which has the names and corresponding hours going vertically down the page, but each month next to each other - horizontaly across the page.

The data is always growing (month by month) so i need something that does it automatically. I would also like it all to come from just the 1 query.

Any ideas?!

Thanks!

 

[SpentGeezer]

Is this what you want to do??

 

[branston]

Thanks for that.
Thats sort of what I want to do... Thats the result I want, but the data is currently all in 1 table and I don't really want to have to split it all into seperate tables. Also as time goes on there are going to be more and more months to report on... and I don't want to have to update the query/report each month.

 

[vbaInet]

What you want to look into is a Crosstab query:

http://www.databasedev.co.uk/crosstab_queries.html
http://allenbrowne.com/ser-67.html

The query can only be used in a report if the Column Heading is static.

 

[branston]

Oh right, Thanks for that - I will have a play and no doubt have more questions later!