All you have to do is create an update query. Start a new query and
select the table that you are working with. Click on Query | Update
Query. Now bring down the field that you want to update in the Field
list. In the Update To field type in the number that you want to
display in all the fields (in your example, 1314). Now run the query
by clicking on Query | Run.
"Sean Ryan" <smryan (AT) worldnet (DOT) att.net> wrote
Quote:
Is there an easy way, in a simple Access table with a lot of records, to
populate the same field of every record with the same peice of data? for
example, to put the same number, 1314, in the selected field of each record,
without manually entering it repetitively? |