Print records that have not been printed yet

[Becker]

I have a table called "unload" which people are constantly adding records too from a form throughout the day. I created a button to print the records from a query called "unload query". I want it to only print records that have not yet printed, but as of right now it prints all of the records. Any help is much appreciated. Thanks!

[zmbd]

There are several ways to handle this... I use a batch table approach so that I can reprint a batch of records incase the printer eats them and I also have a record of when the records were printed. The solution just depends on what you're after in the long run.
-z

[Mihail]

Or you can define a new field in the table: say... "IsPrinted" (Yes/No type) with "No" as default value.
Then, any time you print a record (or a set of records), change "No" to "Yes" for that record(s).

Of course you can design even a better query to show only records with "No" in the IsPrinted field.

Of course you can imagine other ways.
As example the IsPrinted field can be as type Date/Time with Null as default value.
The query will show only records with Null in IsPrinted field.
Other queries can show the records that are already printed between StartDate and EndDate.

And so on.

Cheers !