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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1
Access Query problem 1
Transfer query result to a table field? 7
Access Sequentially numbered column that resets with each new sample 0
Inventory transaction table - set up 5
Calculation in SQL Union query 2
VLOOKUP, a table with text and numerics 7

Back
Top