Copying fields to multiple records

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!
 
D

Douglas J. Steele

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.
 
M

Marcos

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
 
Top