Database Split?

[Andre Adams]

Hey guys,

I'm wondering. Right now have a table that combines 3 years worth of data.
I want to keep the 3 years combined in one table, but in addition, break it
out by year. The only problem is, how do I update this year table when all
of my imports go into the combined table? Would I have to import the
information twice? Once in the combined and once in the year? Please Help!

Andre

 

[Jerry Whittle]

Keep all the data in one table. There is seldom, if ever, a good reason to
put the same kind of data in more than one table. Putting the same exact data
in more than one table is always a bad idea.

I'm curious: Why would you want to split the data up by year?

 

[Ron2006]

The solution is that there is some field in the table that will tell
you the effective year of the information for each record.

If you then want to select the information for a specific year you
supply in one way or another the year of records that you want.


Ron