Impossible Report

[ConfusedAccessGuy]

Hi all,

I was wondering if there was any possible way to do something like the link
below in a report? If so some tips or tutorials would help immensely. I am
using access 2000


http://img516.imageshack.us/img516/136/reportsi7.jpg

 

[Maurice]

Looks like you can use a crosstab query for that. First try the crosstab
query wizard to produce the output. Just follow the steps. Then create a
report with the reportwizard based on that query. See if this is what you
mean and let us know. If this is actually what you want we can specify
certain pointers for you.

Maurice

 

[ConfusedAccessGuy]

Can someone explain the crosstab query? I'v tried using it but im confused.
An example from the link earlier of what would be the header or other fields
would be really helpful
Thanks again!

 

[Maurice]

Ok, try the following link: http://www.tek-tips.com/faqs.cfm?fid=2868

Maurice