Oct 14, 2003 #1 volant Programmer Feb 4, 2003 9 US I need to print a record based on a value in a row/field, then update that field so as not to print the same record again. Any ideas? Thanks.
I need to print a record based on a value in a row/field, then update that field so as not to print the same record again. Any ideas? Thanks.
Oct 14, 2003 #2 JayKusch MIS Oct 30, 2001 3,199 US create a bit field call Printed. Once you have printed the record you need update it w/ a 1. Thanks J. Kusch Upvote 0 Downvote
create a bit field call Printed. Once you have printed the record you need update it w/ a 1. Thanks J. Kusch
Oct 14, 2003 Thread starter #3 volant Programmer Feb 4, 2003 9 US Jay, thanks for the response. I have a field called printed. What I'm struggling with is how to update the field in one particular record, and not all records in the table. Upvote 0 Downvote
Jay, thanks for the response. I have a field called printed. What I'm struggling with is how to update the field in one particular record, and not all records in the table.
Oct 14, 2003 #4 JayKusch MIS Oct 30, 2001 3,199 US Is there a unique/key field w/in your table? If not, can you create on and apply a seed/incrementing value? Thanks J. Kusch Upvote 0 Downvote
Is there a unique/key field w/in your table? If not, can you create on and apply a seed/incrementing value? Thanks J. Kusch