I need help with copying records

A

Al

I need to copy a set of records for different Patients
(Identified by PatientID field) in a table and then paste
them as new records with new Patient ID. Can someone help?
Thanks
Al
 
J

John Nurick

Hi Al,

Think in terms of using an Append query whose source is the table you
want to add the new records to. Use the PatientID values you want to
select as *criteria* for the query, and use an expression to generate
the new PatientID value for the new records (if PatientID is an
Autonumber and you don't care what the new PatientIDs are, just let
Access generate them for you).
 

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

Copy previous record into form field 0
using filter to add new record.. 1
dlookup help 2
sql aggregate query 3
Create a dynamic master file 1
retrive the values if the patient already exist 0
Problems with Recordset.clone Combo Box 2
Macro to select and delete levels of a document 2

Top