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!