Filling Down

[Guest]

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.

 

[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

 

[Joseph Meehan]

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.

Can I assume that future records or some existing records will not have
that same information in that field as those 9,000?