Lists into Strings

[Cheryl]

Table1 has a large text field called "Charges" for each Case#.

Table2 has a field called charges and is set up like this:

Case#X Description1
Case#X Description2
Case#X Description3

How do I convert Description1, Description2, and Description3 under
Case#X into Table1.Charges as Description1/Description2/Description3,
all on the same line and separated with slashes?

I appreciate any help!

 

[[MVP] S.Clark]

Duane Hookums Concatenate function.

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

 

[Cheryl]

That seems rather complicated -- is there no way to do it with a query?

 

[Guest]

Maybe try the solution that I gave to QUERIES -- In
Access, How do I Concatinate items in the same column?
3/7/2005 10:09:02 PM