Unanswered: Concatenate Variable Values in a Query
I need to know the best way to accomplish the following:
I have a query (qryClaims_Actions) that shows 2 fields ClaimAutoID and OfficeActions - each action is a seperate record entered in Claims_OfficeActions table
Using the rows below, I want to dynamically build a query (qryClaimsCombinedActions) that has 1 line per ClaimAutoID, but will combine the actions into 1 field..... (see 2nd query below), with a comma between each...
Some claims may have action, while others may have 1, 2, 5, 10, who knows how many....
2nd query - group by ClaimAutoID - combine all actions in 1 field
112 AB, CD DE
114 AB, CD