Crosstab hell

[elgoober]

Chaps

I want my ideal report to look like this

across the top months jan feb etc

rows would show product

in the field a volume calc and a value calc - crosstabs only support one value - (other than using a pivot table ) has anyone any thoughts on this

Big thanks for looking

Paul

 

[Sohaila Taravati]

I had the same problem, but it took me a while to figure it out. There might be easier ways to do this!
First make a "Make table query" and call it "Dynamic Data", out of the information that you want. Then make 2 crosstab queries out of your Dynamic Data for each of the values that you want. Then make another query out of your 2 croostabs and run your report out of the last query. This way you can actually put in 10 values if you want. The only catch is, that you have to make a button for your "Make table query" before running your report, so the data would be fresh!

I hope I didn't confuse you

Good luck,

Sohaila