Combining value in multiple rows into new field

[stricklanpbs]

I have a database with CPT codes and Revenue Codes

CPT Primary Rev Code Alternate
99212 270
99212 470
99212 540

for an export file I need to combine all of the codes into one field separated by commas;

CPT Primary rev Code Alternate
99212 270 470, 540

I am not good with modules just yet and need some help.

Ideally, I would like a query that would create a new table that I could create an excel export file.



Thanking anyone in advance for their help

[ajetrumpet]

in access, you'll need to loop the dataset in code. do you need them grouped, one comma delimited field per CPT code?? if so, you'll dataset will be opened with this code:

rs = currentdb.openrecordset("select cpt, secondfieldname from table " & _
"order by cpt")

[stricklanpbs]

Yes, they will be separated by one comma after each one.

[stricklanpbs]

And no grouping.

thank you

[ajetrumpet]

OK, well good luck with the code writing. If you need assistance with some of the syntax let us know.