Results 1 to 2 of 2

Thread: Archive Records

  1. #1
    Join Date
    Dec 2003
    Posts
    138

    Smile Unanswered: Archive Records

    Is it possible to archive previous records either in Access or in an Excel file to keep for historical data?

    Here is the problem:

    I want to create a training database for employees. This database will let us know which trainings are due for an employee. The problem is; I want to be able to not only enter the date that training was done, but NOT overwrite any previous training for the same training.

    i.e.
    Total Quality: 3/7/02
    Quality Refresher: 3/7/05
    Quality Refresher: 3/7/08
    etc.

    I don't want to lose the previous dates of training.

    Thanks for your help!

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes...

    All you'd need is a TRAINING HISTORY table to hold the data. When someone does a training course, just add another record to it. That table would be related to your EMPLOYEE table.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •