I've thus far created a simple Access database to keep track of all the pumps my (mining) company uses.
What I want to do, is create a form which will automatically archive previous data if new data is written into it. For example, I have a pump that is operating from the 21st of April. Then, it fails on the first of May. I would like to allow a user to enter new data into the form (change pump status from operating to failed and the dates) to display the current status, but not lose previous information by storing it in another table.
Then, if anyone should want to call up the history of a particular pump, they can just look it up in the archive table, and all its past failures and startups can be found.
Can someone help me with this? I don't have much time...
Thank you very much in advance,
Stef the Noob