In Access, how do I copy one field into several others?

  • Thread starter Thread starter Guest
  • Start date Start date
How do I copy the information from one cell into several other cells in the
same column?
Click to expand...

Well... generally you wouldn't. On the rare cases where you would, an
Update query would be the appropriate tool.

Access Tables don't have "cells". Spreadsheets have cells; tables are
different. Could you describe your Table, what's in the fields (the
more common name for the box you see), and what you're trying to
accomplish?

John W. Vinson[MVP]
 
I have had to insert into my table our member's ID numbers after several
years of entry. So I want to sort my column with members names and then in
the next column put their ID. Since the member is in there several times I
want to copy their ID number and paste it into several fields. I know I can
use ctrl + (') for one line at a time but I want to do this faster than that.
Thanks, Nancy
 
I have had to insert into my table our member's ID numbers after several
years of entry. So I want to sort my column with members names and then in
the next column put their ID. Since the member is in there several times I
want to copy their ID number and paste it into several fields. I know I can
use ctrl + (') for one line at a time but I want to do this faster than that.
Thanks, Nancy
Click to expand...

I would (VERY STRONGLY!!!) suggest that you create a separate Member
table, with the MemberID as its Primary Key and the member name as
separate text fields (LastName, FirstName, MiddleName, Suffix, maybe
Title).

You can then create an Update query joining this table to your current
table, joining by the name field(s), and update the MemberID. You can
(and should!) then delete the Member Name field from the table where
it's repeated; you can use a Query to join the member table to this
table in order to display the name associated with the ID.

Could you post the names of the relevant fields and typical contents
of your existing table? It should be pretty easy to set up an Update
query to do this right.


John W. Vinson[MVP]
 
Back
Top