Enter values into existing field

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

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.)

I notice that entering "1" into the default box will
add "1" to new entries. I'd like "1" entered into all
existing records of the new field.

Thank you in advance,
Ellen
 
Just create an update query. Bring the field you want updated into your
columns and in the update to line, put 1.

Hope this helps.
 
Thanks, Jackie. Yes I did update it with an update
query. Just hoping there would be a simpler way.
 
Back
Top