Append Query Issue

Jan 23, 2014
Reaction score

My append query is adding too many rows. I have an add staff to training form, which uses combo boxes to do so.

The entries are added to the attendance table. I want to append these rows to the staff training history table (macro), which in turn will update each staff record.

What I have works in a way, but it appends all entries from the attendance table each time the macro is run, that is, there are many duplicates.

What can I do to make sure that only the current training's attendees' records are updated?

Any help is much appreciated. Thanks!


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