Crosstab to Report/Word

[Chimp8471]

is there a way to output a crosstab query to some kind of report, either a built in report or a Word doc.

i have searched for ages but just want a simple tool to do this.

 

[Štef1]

Hello Chimp8471
If you have a "Solutions.mdb" look at it. there you'll find
"Create advanced reports", (select it) and "Create a
crostab report with dynamic column headings".
If you have not "Solutions.mdb", look at my
"DemoCrostabA97.mdb". It is a short example.
First open form "OpenMe".

 

[vjb75]

Attention Shtef...

Hi shtef, When i print your report from the A97 example (rptModSizeCrosstab)the table doesnt look the same as it does in the print preview. This is what is printed:

Mod: Size:1 2 3 5
4 0 2 2 0
4 0 2 2 0
4 0 2 2 0
4 0 2 2 0

Any ideas to as why this is happening? repainting, memory issues?

thanks.

vjb.