Print only records added since last print (1 Viewer)

[Serendipityww]

How can I print a report showing only information from records that have been added since the last time the report was printed? For example, I want to add students to the database as they register, and then each time a new lab assistant comes in he will print labels for added students. Is a times recorded somewhere when a report is run? Thanks so much.

 

[Atomic Shrimp]

What you need to do is add a Yes/No (let's call it 'Printed') to your table of students.

Include the 'Printed' field in your report's record source with criteria False, so that the report only shows records with the FALSE value against them.

Add some code or a macro to the command button that the user clicks to print the report that runs an update query to set all of the 'Printed' field values to TRUE (make sure this action is placed after the code that runs the report.

Any records added after the report is run will have FALSE in the 'Printed' field, so the report will only find those records next time.


HTH

Mike