New Field with Default value to Existing Table with data

  • Thread starter Thread starter Mark Mesarch
  • Start date Start date
M

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
 
Don't use the Find & Replace Dialog. Write an Update query, with IS NULL as
the criteria.
 
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
 
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!)






.
Click to expand...
 
Back
Top