Creating a log

[Spruk_77]

Hey all,

I thought I had this problem solved but I ran into more problems. I would like to use the database attached to create a log of all the cards I issue out. The problem I run across is when a person quits I want to be able to delete them out of the database, but have their record of the card they were issued remain. I can have the Social remain but would really like to have the social and last name among other things. I tried to append to a table using a append query and make a history table, but it tends to double on records every time I run the query and sometimes just does not append any records. Thanks for any help.

 

[ghudson]

You should not delete the person. I would add a new "Terminated" [Yes/No] field to your table and mark the person when they quit.

 

[Spruk_77]

Ok, I think I may end up doing that. Can anyone think of a way to say hit a button and it will print out a list off all the people that have left in the past 2 years and then delete them. I am requiried to destroy the records after two years.

 

[ghudson]

Create a delete query with your date range.

 

[Spruk_77]

Ok stop making things so dang easy.

Thanks for the help