Merge of data but not all. (1 Viewer)

[New2SQL]

I have data in excel where 1 contact is known by many people such as:

New2SQL - Access Forum - David Beckham
New2SQL - Access Forum - Coby Jones
New2SQL - Access Forum - Daniel Dichio

I am trying to macro this so it appears as follows:

New2SQL - Access Forum - David Beckham, Coby Jones, Daniel Dichio

any advice?

cheers.

 

[Mike375]

Here is a little data base that was made by forum member Ken Higg that with a bit of modification should do what you want and especially if Access Forum is in every row.

Check the table Medications. tempMecidations has no entries. Open the form Form1 and click Run Routine and then close and check tempMedications table.

You can't use macros for this type of thing.

 

[New2SQL]

thanks for the advice above but there is an error when i try and run the form1

alternatively, instead of doing this in a macro, could it be done in either Access or sql query analyser?

the data is originally coming from there so if i could manipulate there that might make it easier?

 

[Mike375]

It just worked for me and that was using the attached zip file