making a History Table for Access

[Guest]

I have a database used for work holding inmate information- once an inmate
releases I would like to have a table to send those files to without
completely deleting them. How do I do this? I am having trouble with
make-table query.
I also want the option to retrieve them back to current if the inmate comes
back.

 

[Lynn Trapp]

There shouldn't be any need for an extra table. Merely add a field to your
current table that designates whether or not an inmate is "current" or
"released." Then, you can easily change that back if the inmate in
reincarcerated.