Filling a New Field with same Value

[FJB]

Is there an easy way to fill a new field with the same value for the
existing records only? New records will have to have this field
completed appropriately. Thanks for your help.

Frank

 

[Jeff Boyce]

Frank

This may not be enough information to give you good advice. "...the same
value for the existing records..." -- do you mean you want every record to
have the same value? If so, why bother saving the value, since every record
has the same value...?

More information, please...

Jeff Boyce
Microsoft Office/Access MVP

 

[Pat Hartman\(MVP\)]

You need to run an update query that will apply the default value to the
existing rows. You can then make the field required in the table definition
and add a default if you need to.