[AccessD] Advice on a table transformation

Maybe it would have been the fastest way for you, but I did it with a
bunch of SQL queries and UNIONs (thanks BIG to Gustav for his
assistance). The splendid side-effect of this approach is that a
datasheet form based on the query automatically includes future columns!
Beauty!

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
- Beach Access Software
Sent: Sunday, August 22, 2004 10:04 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Advice on a table transformation


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.

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com