New Field with Default value to Existing Table with data

[Mark Mesarch]

HI,
I have a existing table with data. I want to add a new
field to this table with an default value. When I add the
new field, the value of this field in the existing records
is not the default value it is blank. How can I easily
assign the default to the existing records? I have tried
replace, but I cannot seem to find what to search for in
this field. Is it something like a "null" ? If so, how
to I enter a "null" into the "FInd What" field of the FIND
and REPLACE Dialog box?
Thanks for your help!!!
Mark

 

[Douglas J. Steele]

Don't use the Find & Replace Dialog. Write an Update query, with IS NULL as
the criteria.

 

[Rick B]

You need to build an update query and change the value of all the records in
the table.

Rick B

HI,
I have a existing table with data. I want to add a new
field to this table with an default value. When I add the
new field, the value of this field in the existing records
is not the default value it is blank. How can I easily
assign the default to the existing records? I have tried
replace, but I cannot seem to find what to search for in
this field. Is it something like a "null" ? If so, how
to I enter a "null" into the "FInd What" field of the FIND
and REPLACE Dialog box?
Thanks for your help!!!
Mark

 

[Mark Mesarch]

Many Thanks!!!!!!!!!!!!!!!!

-----Original Message-----
Don't use the Find & Replace Dialog. Write an Update query, with IS NULL as
the criteria.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)






.