Producing a Report from Crosstab query

A similar question has been asked several times before, but none have quite answered mine sufficiently.
I have an Access crosstab query which is used to produce a Report. The problem is the columns that the query produces are different each time. The report needs to know which columns to expect, but it's impossible to know.

Is there a way around this?
rick_dangerAsked:
Who is Participating?
 
mayank_joshiCommented:
Following Article may help:-

http://allenbrowne.com/ser-67.html
0
 
Jeffrey CoachmanMIS LiasonCommented:
Sure, see these links, and get ready to rock...
(Hope you are good at VBA coding...)

http://support.microsoft.com/kb/328320
http://www.blueclaw-db.com/report_dynamic_crosstab_field.htm

;-)

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
<A similar question has been asked several times before, but none have quite answered mine sufficiently.>
This is because this is not inherently an easy thing to do...

So I am not sure any posts here will make this any less painful...

;-)

JeffCoachman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.