Append?

  • Thread starter Thread starter Saylindara
  • Start date Start date
S

Saylindara

I have 2 tables - Events and Employees
And a subform created from a link table EmployeeEventLocation to show who
attended, where and when etc.
3 events are very similar and I want to merge them into one.
What would be the best way to go about this?
 
Hi,

Presume you want to keep event 1 and merge the attendees of event 2 and 3
with those rom event 1: use an update query to update the "AttendedWhat"
field in the EmployeeEventLocation table from event 2 and 3 to event 1. You
can then delete doubles if you want to.
 
Thanks Noella, I'll try that.

Noëlla Gabriël said:
Hi,

Presume you want to keep event 1 and merge the attendees of event 2 and 3
with those rom event 1: use an update query to update the "AttendedWhat"
field in the EmployeeEventLocation table from event 2 and 3 to event 1. You
can then delete doubles if you want to.
Click to expand...
 
Back
Top