added check box (yes/no) to an existing table

[clcnewtoaccess]

I added a check box to an existing table. There ar 1000's of entries. I
need to chek about half of them but would like to know if there is a way to
select many and togle the check box. It sill take me a few hours checking 1
at a time.

 

[John Spencer]

Is there some criteria that you can use to identify the records you want to check?

If you could tell a human that this record gets checked based on this data in
the record, then you could certainly write an UPDATE query to check the record.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[clcnewtoaccess]

I'm sorry i didn't make myself very clear. This is an existing database, I
added a field to the table for the check box (yes/no) now every entry in my
table has this check box as unchecked in my table. I can sort the table and
get the ones that need checked all together but is there a way to
multi-select all that need checked and then check them all at once?
I hope this makes sense.

 

[John Spencer]

I know of no way to select 10 records (or 22 or 17) and check all the
check boxes in the selection.

Since you can sort the records and get the records grouped together, I
would assume that there is a way to identify which records you want
checked. For instance, check all records were the date is between today
and two weeks in the future.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================