for a specific file number, there are multiple ppl names associated with it.


001 Jonny Godfather
002 Mammy Moser
003 Tammy Hilfiger

Using the aggregate expressions, how would i in a query, display

001 Jonny Godfather|Mammy Moser|Tammy Hilfiger

Sum doesn't work..(only for numbers)..and i dont wanna write a function in VB
Do you have to?