Crosstab with Multiple data fields

[billy.rogers]

I would like to make a crosstab query that can have multiple data
fields such as

ProdCode
AcctNo SalesAmt SalesTran RetAmt RetTran

I know how to do this with a pivot table but I am required to have it
in Access. I can also do this with just one data field such as
SalesAmt---I just don't know how to add more than one data field.

Is there some workaround to this problem?

Thanks,

Billy

 

[Guest]

Post a sample of you raw data indicating field names and how you want the
results to look like.

 

[Guest]

I can't provide the exact solution for you but there is a sample of how to
create a multiple value crosstab at http://www.tek-tips.com/faqs.cfm?fid=4524.