Combine one column of table to list on report?

[Guest]

Hello,
What I have is a query that pulls records that I have checked on a form.
The result of the query is somewhat like this:

Set Number Part Number Checked
1234 1 Yes
1234 2 Yes
1234 3 Yes
1234 4 Yes

My report is basically just an image of a checklist and a text field that i
want to populate with the part numbers I select. In the text box I would
like to have the results list on one line like so:

1234-1, 1234-2, 1234-3, 1234-4

Is this possible to do without a lot of coding? I know how to get the 2
fields together to display '1234-1' but I can't seem to pull the results
together in a string. I am very much self taught and am not a strong coder.
I've looked for advice elsewhere but it has been so far over my head that I
can't be for sure if it was what i was looking for.

Thanks in advance,

Bo

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.