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.


[TABLE="width: 868"]
<tbody>[TR]
[TD]COMMITTED[/TD]
[TD="align: right"]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]NOT_WSALE[/TD]
[TD](blank)[/TD]
[TD]Blank[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SEGMENT[/TD]
[TD](Multiple Items)[/TD]
[TD]Except Z[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PRODTYPE[/TD]
[TD](Multiple Items)[/TD]
[TD]Except HEZ & HIZ[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]REPORT_PRODUCT[/TD]
[TD](Multiple Items)[/TD]
[TD]Except Deri, Inv & Equip[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]REPORT_TYPE[/TD]
[TD]Clients other than retail and financial customers[/TD]
[TD]Clients Other than[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]REPORT_FACILITY[/TD]
[TD]Limited[/TD]
[TD]Limited[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Values[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Sum of REPORT_CAT_A_LIMIT[/TD]
[TD]Sum of REPORT_CAT_A_BAL[/TD]
[TD]Sum of REPORT_UNDRAWN [/TD]
[/TR]
[TR]
[TD]GBP[/TD]
[TD="align: right"]2274256.25[/TD]
[TD="align: right"]186463.7082[/TD]
[TD="align: right"]2087792.542[/TD]
[/TR]
[TR]
[TD]EUR[/TD]
[TD="align: right"]239026.7857[/TD]
[TD="align: right"]124191.2301[/TD]
[TD="align: right"]114835.5556[/TD]
[/TR]
[TR]
[TD]USD[/TD]
[TD="align: right"]641221.374[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]641221.374[/TD]
[/TR]
[TR]
[TD]OTH[/TD]
[TD="align: right"]108841.4634[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]108841.4634[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]3263345.873[/TD]
[TD="align: right"]310654.9383[/TD]
[TD="align: right"]2952690.935[/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]

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.