DConCat()

[Joker2]

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?

 

[jackd]

Never heard of DConCat().
See if this is close Microsoft Access tips: Concatenate values from related records

 

[xenou]

I need to join these IDs to record in another field.

Care to say why you are storing data this way? It is not proper structure for storing data in a database.
ξ