Crosstab Query

  • Thread starter Thread starter Hansen
  • Start date Start date
H

Hansen

Hi

I have a table with the following fields:
Region
Supply
Sales
Returns
Revision
Refusals

I however want to report on this table using the Region field as a
column header and the rest of the fields as rows, for eg.
RegionA RegionB RegionC RegionD
Supply
Sales
Returns
Revision
Refusals

Is this at all possible? I have tried to acomplish this using a
crosstab query but maybe I just don't understand how it works.
 
Try this ---
TRANSFORM Sum(YourTable.region) AS SumOfregion
SELECT YourTable.Supply, YourTable.Sales, YourTable.Returns,
YourTable.Revision, YourTable.Refusals
FROM YourTable
GROUP BY YourTable.Supply, YourTable.Sales, YourTable.Returns,
YourTable.Revision, YourTable.Refusals
PIVOT "Region " & [YourTable].[Region];
 
Hi Carl

Thank you, but I can't sum Region as this is a Text datatype like
North, East, South.
 
Back
Top