Moving Data

[Missi]

This may be an incredibly easy question to answer but I am
new to using Access. I need to set up a table that when
new information is entered, the previous information gets
sent to a separate history/log table.

We will be revising documents and sending them out and
need to track where the most recent revision has been sent
but also need to track where old revisions have been sent
without having to cut and paste that information...is this
even possible?

 

[Adrian Jansen]

Add a field on the the table which records where the document was sent. Set
its type to Date-time. Each time a new entry is made, set the Date-Time
field to Now() - the current date-time of your computer. Usually you can do
this automatically in the BeforeUpdate event of the form you are using for
input. Then just create a form to read what was sent, sorted by the
Date-Time field. No need to move records at all.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control