Filling a New Field with same Value

  • Thread starter Thread starter FJB
  • Start date Start date
F

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
 
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
 
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.
 
Back
Top