Fill New Field for All Records

K

Keith

I have added a new field to a table which has a huge amount of records on.

By default I need this field to contain a value.

Is there an easy way to populate this field for every record with the same
value other than copy/paste?

Thanks
 
T

Tom Wickerath

Hi Keith,

Open the table in design view. Select the new field you just added. Press the F6 button to move
focus to the lower window. Select the General tab, if required. Do you see a Default Value
listed?


Tom
__________________________________


I have added a new field to a table which has a huge amount of records on.

By default I need this field to contain a value.

Is there an easy way to populate this field for every record with the same
value other than copy/paste?

Thanks
 
K

Keith

Hi

Yes, there is a default value. It's a numeric field so default value is 0.

However it isn't entered in any of the fields.

Regards
 
G

George Nicholson

DefaultValue will only be applied to new records, not existing ones, so it
is no suprise that your field remains empty.

To update existing records, you need to create an Update query. You specify
the field you want to update and what you want to update it to. You can even
supply criteria (like any other query) so you don't have to update all
records unless you want to.
 
V

Van T. Dinh

You will need to use an Update Query to assign a value for this Field for
existing Records. The DefaultValue will apply only to new Records, not
existing Records.
 
T

Tom Wickerath

Thanks George and Van for providing follow-ups to Keith. I keyed in on Keith's 2nd paragraph,
like a guided missile, and just answered that portion:

"By default I need this field to contain a value."


I didn't pay close enough attention to the entire post.

Thanks,
Tom
 
Top