What is a good title for this question?

[libraccess]

I have a form where there are 3 different functions by Employees, their names to be recorded.
OK so the tblActivity has 3 different FKs all to IDEmployee and so on the relationships the 2nd and 3rd FKs produce tblEmployee_1 and tblEmployee_2. All good so far. And on the form all is also good.
When it comes to the report and I want to display the 3 employees . So I'm thinking my query has all of tblActivity then I add tblEmployee 3 times then I'm sort of stuck. I could choose the fields from each table - but
I want to concantenate ExprNameBuilder: [Surname] & ", " & [NameFirst] for each of them but so far no go
Any ideas please

[June7]

Don't quite understand the issue. You have the data entered and now building report? Why can't you concatenate the name parts for each function?

[libraccess]

Query returns no results, is the query structure of repeating tblemployee 3 times correct

[June7]

That is valid approach. The problem is likely the join type of each link. If it is INNER change to LEFT or RIGHT (not sure which of these outers will result), i.e., set each to "Include all records from tblActivity ..."