Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2015
    Posts
    1

    Unanswered: Creating queries to track changes to large data, Access 2010

    I am trying to create several queries that will consist of large amount of 'changing' data. I'm going to upload raw data from our an external system into Access each week via table format and then I'd like to create queries that would compare the data and see what has been changed.

    Here's an example of what I'm trying to do. This a shortened version of the raw data:

    MANAGER BUSINESS COMPONENTS
    Smith Finance Basel
    Smith Finance SOX
    Jones Compliance AML
    Jones Compliance Anti-Tying
    Smith Compliance AML
    Smith Finance Basel
    John Risk Models
    John Risk Market
    John Finance Basel


    I expect the components data to change as people may be adding/deleting them week-over-week and would like to capture what's been added and deleted by creating queries. I'll have the raw data and will upload to Access every week into a table and will adjust the queries, but how would I setup the query to capture what's been changed (i.e., added/deleted) since the previous week?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Im not entirely certain what you want to accomplish, but you can implement an audit log... IIRC Allen Brownde covers it in soem detail.... but googling 'ms access audit log' ought to get you started
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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