archiving data

[gscma1]

Can you archive data within your database?

I have data for the year 2006, and i wanted to start a fresh year 2007. is it possible to archive my previous data - i still need this data for reports etc, but it would be easier if it wasn't held within my forms.

many thanks

 

[SgtJarrow]

Couple of ways you could handle that...

First would be to move all the "old" records to another table, but then you have to do some union queries and the other considerations when dealing with reports that display the old data.

Second would be to add an archive flag (yes/no) field to the table(s) that stores the data. Set this for any "old" records. When building queries/forms/reports, you can decide to include "archived" data based on this flag.

Hope that helps you get started...

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[lespaul]

i still need this data for reports etc, but it would be easier if it wasn't held within my forms.

Don't start a new set of tables! Filter the forms to only display the current year.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[JoeAtWork]

To echo Leslie, change the form to be based on a query rather than the entire table. Filter the query for the current year.