Reverse a table by a query

[nilses]

Hello,

I would like your help about a query. In attached file, i have a table which name "Table_Hot_Line". I have three fields and i would like to reverse the table. I would like in head of column, the field "Date' and in the head of row, the field "D" and "DT" but i don't know how can i do this reverse.

In my table:

Date....D....DT
1........10...5
2........5.....0
3........4.....2

I would like this if it's possible:

1....2....3
10..5.....4
5....0.....2

Thanks You for you help,

Nilses

 

[Jon K]

You can do it with a series of two queries: a Union Query, followed by a Crosstab Query.

Run the second query in the database.
.

 

[nilses]

Thanks you for your help Jon K, it's perfect.

Nilses