Results 1 to 2 of 2
  1. #1
    dotNet is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Dec 2011
    Location
    Kansas
    Posts
    9

    Create a report with recently changed records


    I would like to create a report that prints only records that have been added or updated since the database file was opened.

    Any thoughts?

    Thanks in advance!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    You need some criteria to filter the records. Like a field that records date record was last hit and another table that stores date database last opened. The criteria would be to retrieve records with date more recent than the last open date. Code in some event (a project or form close) would have to modify the last open date or save another record.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Closing a Dynamically Changed Report
    By EddieN1 in forum Access
    Replies: 5
    Last Post: 07-18-2011, 05:41 PM
  2. Replies: 3
    Last Post: 07-10-2011, 05:37 AM
  3. Create Multiple Records
    By Meccer in forum Access
    Replies: 3
    Last Post: 02-03-2011, 09:33 AM
  4. Replies: 7
    Last Post: 05-29-2009, 04:27 PM
  5. Replies: 4
    Last Post: 01-29-2009, 02:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums