Transform table - columns to rows

D

denton

I have a table with 100 columns, each for a different type of fee. Instead I
want a table with a list of the transactions and each fee as seperate line.
Is there an automatic service that does this instead of fumbling around with
union queries?
 
D

Douglas J. Steele

Nothing built into Access. You either need to create a massive UNION query
(or likely more than one, since I don't believe you can have 100 subqueries
in a single UNION query), or else write VBA code to open a recordset and
process it to create multiple rows in another table.
 
Top