hi guys
thanks very much for your responses.
i should of mentioned the data does not need to be stored in the database i recive it monthly in csv with seperate records for all the pets regardless of the pet owner and essentially have to cancatonate the Pet Names manually and then run a mail...
Hi I hope someone can help.
I have a table with records in like the follwowing examples.
Record 1
ID - 1
AccountID - 123
Name - Mr Smith
Address - 38 The Close
PetName - Tilly
Record 2
ID - 2
AccountID - 123
Name - Mr Smith
Address - 38 The Close
PetName - Chloe
Record 3
ID - 3
AccountID -...