By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,849 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,849 IT Pros & Developers. It's quick & easy.

How do I copy data from one record into many

P: n/a
I am new to Access and have one small problem I can't seem to solve. I have
a database with multiple order records for people. Each person has a unique
ID, and is on the datbase multiple times, but only one of each record has
the address, and phone, etc. I need to copy the data from that record into
all records with the same IDs.

I know I can creat multiple tables, but I need it in a single table so it
can be exported to a mailing/accounting program.

Any ideas would be appreciated.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Copying the data from that record into all records with the same IDs is the
wrong thing to do! Create a query that includes the table with the address,
phone, etc and the table with the data you want to export. You should already
have a relationship between these tables so you should see a line joining the
tables on the ID field. Export the query to your mailing/accounting program.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"LarryH" <lh*******@cox.net> wrote in message
news:1Q0Jb.36558$gN.18048@fed1read05...
I am new to Access and have one small problem I can't seem to solve. I have
a database with multiple order records for people. Each person has a unique
ID, and is on the datbase multiple times, but only one of each record has
the address, and phone, etc. I need to copy the data from that record into
all records with the same IDs.

I know I can creat multiple tables, but I need it in a single table so it
can be exported to a mailing/accounting program.

Any ideas would be appreciated.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.