Joining Tables Verticaly

C

Cory O

I am using Excel to creat sales data, and would like to use Access to store
it. I would like to have seperate years per table (Link) but creat a Querry
to join the table verticaly as that works best using Pivot Tables in Excel.
 
K

Klatuu

It would be incorrect to have separate tables for each year's data. That is
a common mistake. The correct method is to use a field to identify the year
the data belongs to and filter the data for the year you want to report on.
 

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

Turning a 3 column flat file into a "3D" Table 2
Access How to refresh the Access database automatically??? 1
linking tables 2
Append Query 3
Outer Join and a two step query 1
Create Family Tree 3
Make Linked Tables Read Only 3
joining on mis-matched data type 5

Top