Hello, listed below is an example of what I'm trying to do. Any thoughts?
Example of Table
AccountNum Desc Amount Comments
---------------------------------------
112233344445555 #1 100.00 C#1
112233344446666 #2 150.00 C#2
112233344447777 #3 50.00 C#3
112233344448888 #4 200.00 C#4

AccountNum
11 - Corp
22 - Company
333 - Major
4444 - Minor
etc...

I already have a query that Compresses the data by Company, Major, Minor. It sums the amount field, and takes the first row for Description, and Comments

Example of Query Results
AcctNumber Desc Amount Comments
----------------------------------
223334444 #1 500.00 C#1

Select Distinct (Co-Maj-Min)
First(Description)
Sum(Amount)
First(Comments)

What I need to do is instead of taking the first of the description, and comments fields, is to be able to concatenate everything so I would end up with this:

Result Needed
AcctNumber Description Amount Comments
--------------------------------------
223334444 #1#2#3#4 500.00 C#1C#2C#3C#4

Thanks for anything you can help with.

Jerid