How do I copy data from one record into many

  • Thread starter Thread starter LarryH
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

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

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
export records 1
Access Access 2010 import/append data into table w/o overwriting existing records 0
How to export table from outlook into ms access table? 0
Access Automatically Send a notification email once a record is added 0
Reports that sift records from different tables 0
macro to copy a record from a form and paste it into the next reco 5
Pop-up form that creates record that links 1:1 to main form 0

Back
Top