<div>
&lt;A similar question has been asked several times before, but none have quite answered mine sufficiently.&gt;<br />
This is because this is not inherently an easy thing to do...<br />
<br />
So I am not sure any posts here will make this any less painful...<br />
<br />
;-)<br />
<br />
JeffCoachman
</div>


<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

<div>
<div class="content wysiwyg-content">
A similar question has been asked several times before, but none have quite answered mine sufficiently.<br />
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. <br />
<br />
Is there a way around this?
</div>
</div>


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?

Producing a Report from Crosstab query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.