Filling Down

K

Kimbly

This may sound like idiocy but i would like to know how to fill down through
lots of records with the same string. I am entering directly into a table at
the moment and want to enter the same information into one field for about
9000 records, too many to keep pressing Ctrl + '. Please help. Thank you.
 
T

tina

create a SELECT query to return all the records you want to update. in query
design view, on the menu bar, click Query | Update. in the field you want to
update, enter the value you want on the Update To: line. then click the Run
button on the toolbar.

NOTE: it's a good idea to make a copy of your database, *before* you do
this. that way if you make a mistake you'll have the backup copy to fall
back on.

hth
 
Top