change value with report

[Stephen]

I have a report that has worked fine for years on my system.
The query is based on one yes/no check mark on about 10 records every
quarter but now it has 50 records.
To much to change by hand.
After I run the report I need to set this field to false and set a
second field to true.
Can someone tell me were to look to find a solution

Thank You
Stephen

 

[Ken Snell \(MVP\)]

Use the report's Close event to run an update query that will reset those
fields' values for you.

 

[Stephen]

thank you Ken

Stephen