quicky input data for 3000 records

B

babs

I have added a field to an existing table that is a yes/no field that has
3000 records. all of the records for now should be checked in (yes). I know
I can set the default to yes for new records and that you can use ctrl ' to
repeat what is in the field for the previous record. Is there any QUICKER
way to input checks for all of the existing records for this table.

thanks so much,
Barb
 
M

Marshall Barton

babs said:
I have added a field to an existing table that is a yes/no field that has
3000 records. all of the records for now should be checked in (yes). I know
I can set the default to yes for new records and that you can use ctrl ' to
repeat what is in the field for the previous record. Is there any QUICKER
way to input checks for all of the existing records for this table.
Click to expand...


Create and run an UPDATE query.

UPDATE tablename Set yesnoname = True
 
Top