[AccessD] Advice on a table transformation

Arthur, if it's a one-time deal, could you export to Excel and use the
Transpose feature? 

Susan H. 

Arthur:

Seems like code would be the fastest way.

Set up a table with as many fields as there are records in the current
table.  Create the first record in the new table as the dates of the old
table.

The first field in each record of the new table would be the field name of
the column in the old table.

Then loop through the first table sorting the data into the records of the
new table.  The report would then just be a mirror of the new table.

I use this 'temp table' approach all the time for complex reports instead of
fooling around trying to get complex queries to do it.