Using a Pivot Function

[aravindkm]

Hi All,

Can you please help in creating a pivot like function in access. Where I have data from that data I was required to create a Pivot function.

The Output should be like below.

COMMITTED	1	1
NOT_WSALE	(blank)	Blank
SEGMENT	(Multiple Items)	Except Z
PRODTYPE	(Multiple Items)	Except HEZ & HIZ
REPORT_PRODUCT	(Multiple Items)	Except Deri, Inv & Equip
REPORT_TYPE	Clients other than retail and financial customers	Clients Other than
REPORT_FACILITY	Limited	Limited
	Values
Row Labels	Sum of REPORT_CAT_A_LIMIT	Sum of REPORT_CAT_A_BAL	Sum of REPORT_UNDRAWN
GBP	2274256.25	186463.7082	2087792.542
EUR	239026.7857	124191.2301	114835.5556
USD	641221.374	0	641221.374
OTH	108841.4634	0	108841.4634
Grand Total	3263345.873	310654.9383	2952690.935

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>

Can anyone help to build a pivot in access

 

[ranman256]

make a query to pull the data you want from the table, Q1
then use the Query Wizard to make a CROSSTAB query, using Q1.
it will ask you the field to use for rows,
the field to use for columns,
and the value intersecting.