concatenate the text fields for similar records

[mansied]

Hello All,

I have a table with the following fields: Notification, Act Item, Act Code Grp, Act Code, Act No, and ACT_TXT.
When I perform a GROUP BY on the fields Notification, Act Item, Act Code Grp, Act Code, and Act No, I get one or more records.
I need assistance in concatenating the ACT_TXT field so that I have a single record for each group in another table with concatenated ACT_TXT field of them .

 

[MajP]

I use the @theDBguy code to do record concatenation

Code Snippets

Some people like this one, but I find it more complicated to use

Microsoft Access tips: Concatenate values from related records

Return a string containing the values of related records.

allenbrowne.com

 

[Pat Hartman]

It is normal for comments (if that is what these are) to be stored in separate records if they are made at different times or by different people. I can't tell by your column names what type of data you have or whether it makes sense to combine them.

If this is a permanent cleanup and you will delete the original table after the rows have been merged, then use the function that Maj suggested in an append query so you do the whole thing in one step. Make sure the new table has a unique index to prevent this duplication in the future and make sure the new text field is Long Text rather than Short Text.