Mark all records with default value

[SallySC]

I have added a new "yes/no" field to a table. I made the Default Value "yes"
which will apply to all NEW records. How do I make all existing records
"yes" without clicking on each and every one?

 

[Kevin B]

Create a new query and from the query grid, click QUERY in the menu and
select UPDATE query. Drag your new field to the first column in the FIELD
row of the grid, in the UPDATE TO row enter the value TRUE and in the
CRITERIA row enter FALSE.

Then run the query and clcik YES at the confirmation dialog box.

 

[Bruno Laurans]

strdyfygjhjkhj


Le 28/03/08 21:31, dans (e-mail address removed),

 

[Bruno Laurans]

ezrtyyutyh


Le 28/03/08 22:35, dans (e-mail address removed),

 

[SallySC]

Incredible! Thanks!!!
--
Sally

Create a new query and from the query grid, click QUERY in the menu and
select UPDATE query. Drag your new field to the first column in the FIELD
row of the grid, in the UPDATE TO row enter the value TRUE and in the
CRITERIA row enter FALSE.

Then run the query and clcik YES at the confirmation dialog box.