I can't figure how to concatenate in Access. My data looks like:
member_id, dialer job
1, Job1
1, Job2
2, Job3
2, Job4
3, Job1
3, Job2
I want it to be
member_id, dialer job
1, (Job1,Job2)
2, (Job3,Job4)
3, (Job1,Job2)
Seems like the below query should work from what I've searched on the googleverse, but I keep getting "Undefined function 'Concatenate' in expression".
Code:
SELECT [member_id], Concatenate("SELECT [Dialer Job] FROM [GVR Loaded Into Dialer1] WHERE member_id=""" & [member_id] & """") AS Dialer_Job
FROM [GVR Loaded Into Dialer1];
Thanks for your help