Empty field to be filled with same entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ellen - 10 Aug 2004 13:05 GMT

Hello,
I'd like to add another field to my table and for whole
field to have all the same entry, namely the
number "1". How can I do this? (I know how to add a
field-- just need to know how to give it all the
same entry.)

Thank you in advance,
Ellen

Reply to this Message

Tim Ferguson - 10 Aug 2004 14:42 GMT

> I'd like to add another field to my table and for whole
> field to have all the same entry, namely the
> number "1". How can I do this? (I know how to add a
> field-- just need to know how to give it all the
> same entry.)

Two ways: you can either set the DEFAULT value of the field set to "1"
(only if you are using ADO, since the older versions of Jet accessed by DAO
don't have the DEFAULT clause); or you can do a simple

"UPDATE mytable SET mynewfield = 1;"

Hope that helps.

Tim F

Reply to this Message