change value with report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stephen - 20 Mar 2008 00:05 GMT

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

Reply to this Message

Ken Snell (MVP) - 20 Mar 2008 00:27 GMT

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

Signature

Ken Snell
<MS ACCESS MVP>

>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
[quoted text clipped - 6 lines]
> Thank You
> Stephen

Reply to this Message

Stephen - 20 Mar 2008 13:47 GMT

thank you Ken

Stephen

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

Reply to this Message