Pivot table ref

[Bobby100]

Hi,

I have a table as pasted above that I need to PIVOT.

If the columns are hard to read they are..

REF_ROW_NO REF_SOURCE_FIELD REF_SOURCE_VALUE

I would like the table pivoted so that each ref_row_no is combined together.. hence for ref_row_no =2, i would have a column for value desc with a value of 'Controlled River' and a column called VALUE_ID with a value of 313.

Is this possible?



Thanks,

Rob.

[ranman256]

Can you not use a Crosstab query?

[Bobby100]

No I need to do this with SQL at the moment as this is in Oracle SQL developer

[CJ_London]

or just change the table view to pivot table and drag your columns to where required

[ranman256]

access can run the crosstab sql from Oracle.