Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    2

    Unanswered: Help needed with change tracker please.

    Hello,

    I need to build upon the attached database.

    At the moment users can enter dates into either of the 4 date fields:

    Date 1
    Date 2
    Date 3
    Date 4


    I need to set up a new table which will keep a record of when these dates were changed.

    For example if a user places a date into date 1, I would need an entry to be placed into tbl_history with the following details captures:

    historyid | id | date field changed | new date placed into field | ---headings
    date 1 20/12/2005

    Then if the following day they changed the value in date 1 again the table would look like this :

    historyid | id | date field changed | new date placed into field | ---headings
    date 1 20/12/2005
    date 1 24/12/2005

    Can someone help me to achieve this.

    Thanks

    Andy.
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2005
    Location
    New England
    Posts
    35

    Try this

    Not sure it's quite what you want...

    http://allenbrowne.com/AppAudit.html

Posting Permissions

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