Clearing all check boxes in a column at once

M

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
 
J

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".
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top