existing checkbox value change in tbl

[perryclisbee via AccessMonster.com]

Hi,

I have 950 existing records in a given table. I added a checkbox field, and
now want the default value for all the existing records to be true(box
checked). In the table, I set the default value to true, which will enable
future records to begin with a checked box, but my existing records remain
unchecked. Is there a good way of updating the checkbox value in the table
for all the existing records to reflect checked?

Thanks,

Perry

 

[Duane Hookom]

Create an update query that updates the yes/no field to -1.