How do I concatenate a field from multiple records?
I am attempting to create a query that contains a field that lists the employee departments. The goal is to use this query in report headers, ie:
EMPLOYEE: 1111 DEPARTMENT: A, B, C
detail, detail, detail, etc
I've concatenated the Employee names before, but I'm not sure how that works when I'm refering to the same field in multiple records. I've attached screen shots of the query in question.