Mark all records with default value

S

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?
 
K

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.
 
S

SallySC

Incredible! Thanks!!!
--
Sally


Kevin B said:
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.
Click to expand...
 
Top