How to fill a copied table with default data 1

[merlynsdad]

I have copied a table from another database into a new db. I've added a field, and want the default data in that field to be "CR". New records will get this default, but is there any way, without writing code, to push the default entry into the existing records? I'm in Access 2003.

If the square peg won't fit in the round hole, sand off the corners.

 

[PHV]

Use an update query, eg:
UPDATE yourTable SET yourField='CR' WHERE yourField IS NULL

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886