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![]()