Change Rows into Columns

[Guest]

My query gives me this

Date1 10 9 8 7
Date2 20 10 5 1
Date3 30 25 3 2

I want this

Date1 Date2 Date3
10 20 30
9 10 25
8 5 3
7 1 2

Any suggestions??

 

[Michel Walsh]

With a recordset? use the method GetRows which retrieve data into an array,
and the indices are somehow, "transposed".


See the help file about the GetRows method for more details and examples.



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

You need to first normalize your data with a union query like:
SELECT DateField, FldA as TheValue, "A" as Fld
FROM query
UNION ALL
SELECT DateField, FldB, "B"
FROM query
UNION ALL
SELECT DateField, FldC, "C"
FROM query
UNION ALL
SELECT DateField, FldD, "D"
FROM query;

Then, create a crosstab that uses Fld as the Row Heading, DateField as the
Column Heading, and Sum(TheValue) as the Value.

 

[Guest]

Try to do that in Excel then import the sheet to the access


Marco

 

[Guest]

Try to do that in Excel then import to access then