If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
In Access, how do I copy one field into several others?
How do I copy the information from one cell into several other cells in the
same column? |
#2
|
|||
|
|||
In Access, how do I copy one field into several others?
On Fri, 20 Jan 2006 07:38:04 -0800, "Nancy"
wrote: How do I copy the information from one cell into several other cells in the same column? 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] |
#3
|
|||
|
|||
In Access, how do I copy one field into several others?
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 "John Vinson" wrote: On Fri, 20 Jan 2006 07:38:04 -0800, "Nancy" wrote: How do I copy the information from one cell into several other cells in the same column? 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] |
#4
|
|||
|
|||
In Access, how do I copy one field into several others?
On Fri, 20 Jan 2006 10:16:03 -0800, "Nancy"
wrote: 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 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |