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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top