I would like to craete a button that archives historical data...

[wedd]

Hi, I would like to create a button on a form that archives historical data based on existing and previous customers booking information stored in the databse. Ideally, I would like to create a user interface that when they click on the button they can search for old records of customers that can search through a by either typing a date or the customer's name...the records will show all the transactions with the customer...if the customer has been inactive for 2 years...I would still like their data retained and stored on the database in a separate section that has a unique search for that customer's historical data...Is it possible to create this archive feature? If so, what is the process?


Thanking you in advance...:clap:

[HiTechCoach]

The best way I know to handle this is to simply add a field for ArchvedDate. Id the data is Null then it is active. If there is a data then filter it out from the current data.

The idea is to keep all data in the same tables. You shoudl avoid having multiple tables with the same structure.

You will find that keeping all the data in the same table has many benefits. Using multiple tables will make things a lot more difficult.

[Imdabaum]

If I can add my two cents in and encourage you to use the approach HiTechCoach suggests.

When I first started working with Access, I inherited an application that had 4 archive tables and a respective Current_table. I can't count how many times I got calls because data no longer appeared in the current_table.
The end result was adding a yes/no field "Archived" and appending all the archived records back into the current table. Added a single button "Show Archived" which simply applied a filter on that check box. Deleted about 16 queries that were responsible for transfering the records back and forth between the 8 tables. In short, it shrunk the database in size and I got a lot less phone calls regarding that issue.