Crosstab with Multiple data fields

B

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
 
K

KARL DEWEY

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