Append?

[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?

 

[Noëlla Gabriël]

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.

 

[Saylindara]

Thanks Noella, I'll try that.

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.

 

[Saylindara]

It worked like a charm. I couldn't be more grateful.