How do I update a field on reports

[farnorth]

I have set up an .asp vbasic page that reports from a database table. I need to be able to have one field on each record be updated with the click of one button. Essentally after the report is printed I want to change the prinited field from False to True so it will not show up the next time the report is run. Is there a way to update all of a certain field with one action?

Thanks
Bob

 

[Cheech]

You could use something similar to

UPDATE tableName SET Field1='True' WHERE RecordID IN(1,5,8,12)

Cheech

[Peace][Pipe]

 

[farnorth]

Thanks Cheech, Since I am running a report, would I have to create a form on the report page to be able to click an update button? Or how would I implement the code to update all the records pulled on the report?

This one has me stumped.

Thanks agian.

Bob

 

[Cheech]

You could either have a form that the user submits when the report is generated, or the details could be passed to an asp page that does all of the updating prior to displaying the report.

Cheech

[Peace][Pipe]