Copying fields to multiple records

  • Thread starter Thread starter Elizabeth
  • Start date Start date
E

Elizabeth

Hi all. I'm a new Access user and I'm frustrated that
when I copy fields within a record I cannot paste those
fields on more than one record. Does anyone have info on
how to paste fields on more than one record like you can
in Excel? Thanks for your minds!
 
Access is a database, not a spreadsheet like Excel. Trying to copy the same
value to multiple records is usually a sign that you haven't normalized your
data properly. For example, you shouldn't have the Customer Name repeated on
multiple rows in the Invoice table: it should only exist in the Customer
table.
 
Elizabeth said:
Hi all. I'm a new Access user and I'm frustrated that
when I copy fields within a record I cannot paste those
fields on more than one record.
Click to expand...

Yes, you can.
I wonder what you are trying to do exactly.
Sometimes I manage it copying data to Excel and then copying it back to
Access after some operation.

Marcos
 
Back
Top