Print record once, update Yes/No field verifiying print

[Tommyboy]

I would like to print a group of records, then have a Yes/No field [Printed]
updated in my Jobs table with an update query showing the records were
printed. Then next time the report runs, In my query criteria I will test
for True values on the Yes/No field. Then only the records with the Yes/No
field marked No will print. Any suggestions? Thanks

 

[Allen Browne]

Tommyboy,there's more to this question than meets the eye.

For an explanation of what's involved, see:
Has the record been printed?
at:
http://allenbrowne.com/ser-72.html

The article includes a free sample database that demonstrates how to keep
track of which records have been printed.

 

[Tommyboy]

Thanks for your insight, never thought of the implications of a Yes/No
field. I will do it the right way by marking the records as part of a print
run before being sent to the printer so it can be undone or repeated if
needed.