Transform table - columns to rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top