Automatic Copying of Date

[Aurora]

I am using Access 2003

I am creating a Preventative Maintenance (PM) Database. Lets say a machine
needs to be oiled every 180 days. The last time it was oiled was 1/1/06. I
have a calculated field ("next PM" that adds the "last PM date" (1/1/06) to
the "frequency" (180) days and says the "next PM" is due 7/1/06. This
information now gets entered into the Database. But how do I now
automatically copy the "Next PM" date (7/1/06) to the "last PM date" so that
my calculated field will come up with the "next PM" date of 1/1/07.

I am not real good with programming, so I hope there is a formula somewhere
that will help me do this when I close the form or database each time.

Thank you for any help you can give me - aurora

 

[G. Vaught]

Are you keeping a running history or changing the 1/1/06 to read 7/1/06? If
it is the latter, then create an update query to run after 7/1/06 that will
update last PM date to the date in the Next PM.

If you are keeping a running history, then you need to append the
information.

 

[Aurora]

I want to keep a running history. I know how to append. Do I append the "PM
Due Date for record #1 to the Last PM Date of record #2? Is that what you
are telling me? Aurora