Combining Multiple Rows

[Guest]

I have a table that has the following:

TransactionID Location Account CustNum RateCD
12245 6806 456748 1 8D
12245 6806 456748 1 6F
34576 5709 543789 3 2E

The Desired result is the following:

TransactionID Location Account CustNum RateCD
12245 6806 456748 1 8D,6F
34576 5709 543789 3 2E


Any help would be greatly appreciated!!

 

[Jason Lepack]

I have a table that has the following:

TransactionID Location Account CustNum RateCD
12245 6806 456748 1 8D
12245 6806 456748 1 6F
34576 5709 543789 3 2E

The Desired result is the following:

TransactionID Location Account CustNum RateCD
12245 6806 456748 1 8D,6F
34576 5709 543789 3 2E

Any help would be greatly appreciated!!

Try this.

http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

 

[John Spencer]

See:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

For a solution.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Worked like a charm!!! Fantastic!!

Thank you very much John!