Hi All,
I’m hoping you can help me with a query. I’m trying to amalgamate the data from 2 rows into 1 row if certain conditions are met. I’m not sure this is possible with a query, or if I am going to have to write some code….
Anyway, here is a more detailed description. Suppose I have a query that returns a persons name, and the name of their pet/s

Name PetName
------ -----------
John Fluffy
Sue Floppy
Anne Spot
Anne Flipper

In the case of Anne, who has TWO pets, I’d like to get a result set like this:

Name PetName
------ -----------
John Fluffy
Sue Floppy
Anne Spot / Flipper


Is this formatting possible?
Thanks,
J