Report in Column Format 1

[AllenRitch]

I need to have a report shown in the following manner:

Dept1 Dept2 Dept3 Dept4 Total
Element 1 $300 $40 $0 $100 $440
Element 2 $1,000 $500 $500 $200 $2,200
Element 3 $400 $20 $0 $40 $460
Total $1,700 $560 $500 $340 $3,100

Is this even possible? Currently I have the report showing each Element by Dept. But the users would like to have it go across.

 

[PHV]

Have you tried the CrossTab query wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AllenRitch]

That did the trick.... thanks! That's the first time I've ever used that tool.