Crosstab Report

[Jennifer888]

Hi, there is a need to create a report that shows some 300+ cost centers as columns, some 100+ departments as rows and total dollar amounts, like:

costctr1 costctr2 costctr3...
dept1 $xxxx.xx $xxx.xx $xxxxx.xx
dept2 $xxx.xx $xxxx.xx $xxxx.xx


I can't use the crosstab query due to the 255 columns limitation. And the user insisted the 300+ columns on the report. Any suggestions? Many thanks in advance.

 

[dhookom]

Wow! A piece of paper that allows display of 300+ columns. At even 0.5" per column, that is over 150". Did the user provide a sample layout of how this should look?

I would divide the cost centers into smaller groups or find the user some tape if necessary.

Duane
Hook'D on Access
MS Access MVP