Split Tables for yearly data

[Kodama76]

Hi,

I have a couple tables with sales data split by year...so for example I have one with all the sales data for 2001 called 2001paid

Now I want to run a report or query on these tables so that I can get all the entries for a specific sales code across all the years. How do I make it so that I combine all the data?
i.e.:
CODE PRODUCT PRICE DATE
...... ......blah blah blah $34 1/1/02

so that I have one line for each record in each table that match my criteria(the criteria expression is easy).

I have a sales code table that I linked between all of them and set the criteria for the query or report to the code in that table but when I try and choose the fields that will show up I get everything jumbled up. Is there a better way of doing this?

 

[Jerry Stoner]

You may well have a good reason but...
Why use seperate tables for years? If you had one table you would not have a problem with what you are trying to do. Why not use 1 table then use queries if you need to view only one years data?

 

[Kodama76]

I'd agree with your suggestion...there were just so many entries that I wanted to make the other queries and reports that only had to deal with one year faster by keeping them split.

I'm just going to combine them all I guess since it would be a heck of a lot easier that way.

Thanks

 

[Jerry Stoner]

Good, I'm sure that is the way to go.
Good luck.