How to paste to many records?

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Can someone tell me if there's a way to paste one selection into many
records of the same field at once. I selected several records in one field
and tried pasting, and onle the first record of the selection was copied. I
can do this in Excel with no problem. The only way I can paste the same item
in is to paste it individually, and that takes a very long time considering
it's the same input. the database is related to Automobiles and the field is
YEAR. So if I want to enter say, "1998", into ten separate records that
already exist, I have to paste them individually. Thanks for any info, Don.
 
Hi Don,

Access is not a spreadsheet.

You need to use an update query to do this.

Create a query, setting criteria that returns the ten records. Then you can
go to the Query menu, and choose Update query. In the Update To row under
the Year field (not a good name for a field by the way - Year is a reserved
word), put 1998.
 
Back
Top