So I have a relatively simple query (well I thought it was simple)....
See fig 1...
When I run the query I get what you see in Fig 2.
Problem with it is the caseworker field is from a one-to-many relationship, meaning there can be many ItemCNID linked to multiple caseworkers. So I get the first two rows of data with the exact same data except the caseworker column.... Is there a way in the query to concat the casewoker field, so that instead of having the first two rows (as seen in Fig 2), I only have one row and the caseworker field is concat to be something like JRS, TLR???
There must be a way, I just can't figure it out!