Grouping and Transapose rows with columns

[HendriX99]

Hi All,


I have a table (say TABLE1) similar to this:

COD AMOUNT1 AMOUNT2 AMOUNT3 AMOUNT4

PRT1 1233 123 1256 1344
PRT1 999 123 1256 1344
PRT2 6 123 1256 1344
PRT2 1200 123 1256 1344
PRT2 1233 123 1256 1344
PRT3 1211 123 1256 1344


Now, I 'd like to run a query (or VBA) to froup by "CODE" and transpose the rows, the result should be:

PRT1 1233 123 1256 1344 999 123 1256 1344
PRT2 6 123 1256 1344 1200 123 1256 1344 1233 123 1256 1344
PRT3 1211 123 1256 1344

Is it possibile to get this result via a crosstab query or a VBA code?

thanks in advance

[ajetrumpet]

i don't know about a crosstab, but vba code will definitely do it.

[HendriX99]

any pratical suggetions?
cheers...

[ajetrumpet]

yes...you need some recordset code that will iterate your records and manipulate the data accordingly.

I do not have the time to write it, but that's basically the terminology you need to know.