I had to mask the actual column and table names for proprietary reasons and the actual query is much more involved then the little portion I'm sharing here, but hopefully...

Just wanted to let you know that after a bit of fighting with it, I was successful in using a UDF to put the data in the format necessary, and...

Thank you for the link. I think I can play around with the "medals" example to make it work.

Linda

Funny, I was just going to post a question very similar to yours.

To use an example I found in a book, this is a family:

Date ...