Q: Default Value for new column

  • Thread starter Thread starter Geoff Jones
  • Start date Start date
G

Geoff Jones

Hi

I have an access database, which already has many records in it, which I
would like to add a new column to. In this column, I would like a default
value i.e. each of the existing records will get an extra field with a
default value.

What is the easiest way to do this?

Thanks in advance

Geoff
 
Default values apply only to new records created after the default value was
specified. To update existing records, you can use an update query.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
If the default value is the same for all the fields,create he additional column.
Then create an Update Query and update the fields to the required value.
When your finished,set the default value for the column in Table Design View.

Ta
Theo
 
Back
Top