Deleting Data but stilll retaining it Somewhere

[maintt]

Hi Guys

I have 800 Clients in a database and each week some will leave and some will join, on my form i have StartDate and I also Have ExitDate, my problem is I don't know when they will be leaving, but when they do, we fill in the exitdate and i want to be able to run a query that dumps the data for all that have an exitdate into a history file, i want to run this query at the end of each day, can this be done?

Many Thanks

Maintt

[NoellaG]

Hi,

sure you can archive them into a history database using some action queries (append queries to add the records to the archive tables and delete queries to delete them from the current database). Only, be very carefull with deleteing data. Be sure to check for related data in other tables. If there is no referential integrity you could be producing orphans.
Maybe you could solve the problem by filtering your form on client records which don't have the exitdate filled in?

greetings
NG

btw: not all of us are guys......