Merging Multiple fields Into one field

[msk7777]

Hello all,

I have a table which has each claim as a single record. A client wishes us to provide the data in a format that lists the each procedure on its own line.

I have attached a highlevel example of what the data currently looks like and what the query results should look like.

So I need to create a query that would repeat the Claim Number and place all the Procedure fields into one field.

Does anyone have any suggestions on how I should approach this?

Thanks!
msk7777

 

[pbaldy]

Your desired result is how the table should have been designed in the first place. A UNION query can do what you're looking for. Search here on that and you'll find many examples.