How do I copy data from one record into many

L

LarryH

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

Arvin Meyer

You may need to revisit the design of your query. You can join the PersonID
from People table to the PersonID from the Orders table, and not have to
copy any data. Something like:

Select PersonID, PersonName, Address, City, State, Zip, tblOrders.OrderTotal
From tblPeople Inner Join tblOrders On tblPeople.PersonID =
tblOrders.PersonID;

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top