Archive Function

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: paul (paul_at_discussions.microsoft.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 00:29:09 -0800

Hi,

ive created a database that tracks our employees which move around quite
alot. i need to keep track of who is in what job at a particular date and
time.

in order to keep historical records, i need an archive function that copies
one record to another table and gives it a unique identifier,,,, is this
possible and can anyone help

thanks in anticipation of help...

Paul