Creating a yearly file from 12 monthly files

[hamburger]

Hi,

I have 12 monthly files with 6 fields in each.

There are client numbers and product numbers as identifiers... there are also fields for volume of usage, costs etc.

I want to create a file that shows the sum for volume of usage, costs, etc. for every Client-Product combination.

I know how to do the summing for each combination part... but I don't know how to create a table that has information for all 12 months... how do I make this table/query?


Thanks for your help! Very much appreciated!!!!!!!!!!!!!

 

[Norie]

When you say files exactly what do you mean?

If you have imported the data into 12 tables you could use a UNION query to combine them all.

SELECT *
FROM Month1Table

UNION

SELECT *
FROM Month2Table
...

UNION

SELECT *
FROM Month12Table

For this to work all the tables need to have the same field names/types.

If you get this to work you could either use it in a make table query or use it for the basis of other queries.