Clearing all check boxes in a column at once

[Mike Hartnagel]

I need to maintain a Little League data base where boxes
are checked as we receive registrations for the season.
To use the database for the next season we need to clear
all the boxes. Any easy way to do this? I'm a relative
neophyte.
thanks for any help.
Mike

 

[Jeff Boyce]

Mike

What is it that your table holds rows of, that you need to un-check all the
rows? There might be another approach...

Good luck

Jeff Boyce
<Access MVP>

P.S. look into Access HELP on an "update query".

 

[Tim Ferguson]

To use the database for the next season we need to clear
all the boxes. Any easy way to do this?

UPDATE MyTable
SET MyField = FALSE

or, in the GUI:-
start a new query and add the one table;
change the type to UPDATE QUERY;
add the one field you want to update;
enter FALSE into the UpdateTo row; and
run it by clicking the red ! mark.

HTH

Tim F