clear checkboxes at end of day for mail merge 1

[emzadi]

Okay. I have a mail merge document that is drawing upon a query in an Access database. In the database, each record has a field, a checkbox, indicating if a certain letter should be sent to that individual. The query pulls up all records with that checkbox checked.

Now I find out that the users will be sending these letters to different recipients each day (was supposed to be a one-time deal in the beginning). How can I, at the end of the day, automatically clear this field in all records at one time, to create a fresh slate for the next day?

Is this possible?
Is there a better way?

Thanks!
Susan >:O> Susan M. Wagner
LAPELS
emzadi1@yahoo.com
susanw@lapels.com

 

[JoeMiller]

You can use an update query to do this:

UPDATE MyTable
SET MyCheckField = 0;

HTH Joe Miller
joe.miller@flotech.net

 

[emzadi]

Aha!
Thanks *:->* Susan M. Wagner
LAPELS
emzadi1@yahoo.com
susanw@lapels.com