Old Records

M

Marc

Currently I have a training database. I have old records in it that I would
like to delete but my management is totally against that. I really don't want
employees in the database that have left our department, I was wondering if
there are any recomendation on how to deal with this situation besides
leaving the old employees in there.

Is there a way to make it easy to import the employees and their records for
employees that have left or who are leaving to another database so I will
have only current employees in my active database.
 
D

Douglas J. Steele

You could put an Active flag on each record, setting it True or False, then
write a query that only returns those records where the flag is True. You'd
then use that query rather than the table.
 
T

tedmi

It is quite common to leave old records in the same table as current ones.
Recommend you add a YES/NO field called "Old" or "Inactive" and then, instead
of using the Employees table, use one of two queries:
SELECT * FROM Employees WHERE Inactive=FALSE
or
SELECT * FROM Employees WHERE Inactive=TRUE

Federal/State agencies often requires you to provide info about both old &
current employees, and this system gives you a very convenient way to do that:
SELECT * FROM Employees WHERE <<whatever the govt. agencies require>>

The alternative of splitting old/current into two tables, then combining
them for special requirements that need both, involves much more programming
for moving records between tables.
 
K

KARL DEWEY

Concur with other posters and add that many employees return and you would
want their training records.
 
Top