Auto Duplicate of Records

D

Daniel

Hello All,

I have a training database that was created by someone that no longer works
for my company. It pulls employees from an employee database. I have a
table SpecTraining that holds the employees training records. I am trying
to find a way to create/duplicate records (there are about 8000) in the
SpecTraining table only for employees from the employee database that have
the Status of Active. Also, when the new record is created, I need for the
Year in the SpecTraining to be the current year. We are having to input
these thousands of records individually now, and would appreciate any help
that you can give. If there is something else that is needed to help with
my problem, please respond and I will give any info I can.

I can do a little VB but am a novice. If examples of code are given, I can
usually figure them out.

Thanks,

Daniel
 
D

Daniel

This Append query works fine, but if I try to run it again, it doubles the
amount of records to append. Why? I have in my query Status with "Active"
in criteria, SSN updating SSN from SpecTraining and Year: Year(Date())
updateing Year of Training from the SpecTraining.

First time prompts for 1000 records. Second time I run it, it prompts for
2000 records. This is the problem I am having. If you can tell me how to
avoid the duplications, I would appreciate it.

Thanks,

Daniel
 
Top