How to transpose a table?

  • Thread starter Thread starter Nguyen Van Hoa
  • Start date Start date
N

Nguyen Van Hoa

I have a table with fields: Year, Sales, Cost of Good Sold and Profit. The
table records financial data year by year.
Now I want to make a report or a query that has column showing years and
three rows showing the financial data.
It means that I have transpose my current table. Supposed that I will
increase additional fields such as Tax, number of Employees etc.
Do you know how to do this?
Thank you very much
 

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

Transpose Access Table / Query 5
Transposing data in Access 2007 Query 1
Financial Year Query 1
Transpose Data that involves subquery 0
Union query or Outer Joins do not create desired results 3
Transposing fields! 1
Map fortnightly data to months - can it be done? 13
Field Name in a Table 4

Back
Top