I need help with copying records

  • Thread starter Thread starter Al
  • Start date Start date
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
 
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).
 
Back
Top