Crosstab Query Value fields

[matthej]

Is there any way to add more than one value field to a crosstab query? Here’s what I have now:

2003 2004
CustomerXYZ $Sales $Sales

Here’s what I want:

2003 2004
Sales Units Sales Units
CustomerXYZ $X X $X X

The only way I know to do this currently is to write two crosstab queries and join them. Is there any other way? What ever the result, however, I need to be able to link that query to a report for formatting. Can you link a Pivot Table to a report?

Any help you can provide would be greatly appreciated…

 

[PHV]

Have you even tried to look at the FAQ area ?

http://www.tek-tips.com/faqs.cfm?fid=4524

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