"Rotate" table in query

[TSchrupp]

Hi all,

I have a table linked from another db with this structure:

Date Contract Field1 Field2 Field3 ...
1/1 A 0.00 0.00 0.00

I need to select the the FieldX column names as data, with the corresponding data as a row into this format:

Item Date Contract Amount
Field1 1/1 A 0.00
Field2 ......

Any help with this one out there? Multiple queries are not a problem, the db will be relatively small, so performance shouldn't be a major issue. I'm not against doing this as a make-table or update query, since the table designs of the two databases are so different.

TIA

Tim

 

[TSchrupp]

I made an error in the new format for this query. It should be

Item Contract Date1Amount Date2Amount ...
Field1 A 0.00 0.00
Field2 A 0.00 0.00

Sorry for the confusion

Tim