All, using access 2016..I have a report with two fields based on a m:m which I resolved with a junction table. On my report I list many clients with the same assignmentID. This is fine but when I have the same client with different assignmentIDs it duplicates the entire record detail. I'm only printing the assignmentID with no other fields but the clients have fields showing more client information. How can I print this record and have the assignmentID in the same line with maybe a , to separate?