Help with grabbing data from query into variable

[pjmatelli]

Hi all,
I don't even know how to search for this one. What I need to do is run a query and then take the value(s) in one field for each record and put them into a variable to be used later. Hope that makes sense...here's an example

Field 1
2456, 2938
5432
1234

Result
"2456, 2938, 5432, 1234"

How do I get to that result? I have tried many different ways of looping and I can't seem to get the code to grab the data correctly. Any help, as always, is greatly appreciated.

TIA

 

[Norie]

Paula

What code are you trying?

This should be a pretty straighforward exercise.

The hard part would be to get the code up and running correctly on some sample data.

Once that's done then all you should need to do is run it on the 'real' thing.