Combing Specific Fields With Duplicate Proj Numbers

[roystreet]

Hello,
Here is a challenge for those out there that know queries well. I have one table that contains the following fields:

ProjNum, MakeModSeries, ID, Reg, & Part

There can be several MakeModSeries per ProjNum.
Each MakeModSeries has it's own ID, Reg, & Part values.

Essentially one project can contain several models of which have their own ID, Reg, & Part values.
I would like to combine all of these values into one record based on ProjNum. If possible, I would like each makemodseries & it's corresponding ID, Reg, & Part values on a new line - As in they would be memo fields & each would have a return or could be separated by an *.

Any ideas? Any thoughts on a better method of doing this?

Thanks,
~roystreet

 

[markros]

You may want to check this thread

http://social.msdn.microsoft.com/Fo...l/thread/b64f2f24-d9d5-41f9-9f26-eced21fa70e1

Hope this helps.