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!
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!
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.