Next Year

[Kirt M]

Tried this question under replication and was told to try
news groups?

We currently have a database for 2003. We would like to
create a 2004 and use it at the same time we are using
2003 at years end. Is there a simple way to do this with
a split database?

 

[Danny J. Lesandrini]

You can copy and paste the original database, rename it as 2004 and
delete the 2003 records ... but some day you will be sorry. Some day,
someone will ask, "How do 2003 sales compare with 2004?" Then you
will be back here, asking, "How do I combine data from two seperate
databases?"

If the year (that is, the date) is the only attribute that differs, then
find a way to keep all the data in a single file ... a single place. Add a
column with the YEAR attribute or give all the records a date field.