I have a query that lists IDs on certain criteria (results will always have 1 record but may have more.)
I need to join these IDs to record in another field.
So for example if my query results are:
ID
5197
5198
5199
I need to display "5197, 5198, 5199" (though I'm not fussed about what separates the IDs.)
I've searched all morning for solutions and there looks to be a DConcat() function, though all the code I have found and tried to use breaks. I'm using access 2007, any suggestions?
I need to join these IDs to record in another field.
So for example if my query results are:
ID
5197
5198
5199
I need to display "5197, 5198, 5199" (though I'm not fussed about what separates the IDs.)
I've searched all morning for solutions and there looks to be a DConcat() function, though all the code I have found and tried to use breaks. I'm using access 2007, any suggestions?