Combine rows into one field in Access

Hi all.

I have an Access 2003 table (myTable) with 3 fields: Manufacturer, ManufacturerID, myProductID.

I have attached an Excel file with sample data.

What I want to do is combine or concatenate the data in Manufacturer and ManufacturerID for every instant of myProductID. So I should only have 2 fields for each myProductID, using the attached sample data it should look like this:


AAA---SONY, PHILLIPS, ABC, DEF, 123, 456, 789

Any idea how I can do this?

Thank you in advance!
Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Not easy but see this sample (query1):
Sim1980Author Commented:
Thank you for your reply boag2000.

I changed the query a bit:

Combined: [MyProductID] & ", " & DConcat("Manufacturer","YourData","MyProductID='" & [MyProductID] & "'") & ", " & DConcat("ManufacturerID","YourData","MyProductID='" & [MyProductID] & "'")

Open in new window

And it worked great!
Jeffrey CoachmanMIS LiasonCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.