Concatenating email addresses from a report into a single string

[jpreator]

I have a report that lists the employees who's recognition has been approved and an email needs to be sent to their managers. The report is grouped by those managers. There is a text box that shows the manager's email address, and then one or more employees will be listed underneath each manager. I'm attaching the report to the email so I do not need anything beyond just the manager's email addresses. I need to combine all the manager's email addresses into a single string to add into the address line of the email. The query that the report is based on has this sql:

SELECT qRecognition.EmpName, qRecognition.Department, qRecognition.Shift, qRecognition.Manager, qRecognition.ManagerEmail, qRecognition.SubmitDate, qRecognition.SubmitName, qRecognition.Recognition, qRecognition.Comments, qRecognition.Status
FROM qRecognition
WHERE (((qRecognition.Status)="Approved"));

Thanks in advance for your time and help.

[Seth Schrock]

Allen Browne has an excellent function already built just for you! See Concatenate Related Records. Just plug in the name of your query and specify the separator as the semi-colon and you should be good to go.