Combine Rows from the same Table

[Hal2604 via AccessMonster.com]

I have a table with the fields:

Account & Cust & Comments

The data came into this table from a system generated report & it isn't
normalized & I am trying to normalize it. One thing I need to do is there
are multiple lines with the same account # & Cust but different comments. Is
there a way to merge the comments together into 1 comment field & then get
rid of the extra rows.

Thank you for your assistance.
Holly

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Hal2604 via AccessMonster.com]

I downloaded the sample db & it looks like that will do what I want it to do.

Thank you
Holly