Ian,

I tried that but in the function I needed to have a 'GROUP BY' clause to get the ID's for each disparate group and as soon as I did that I lost the abliity...

PS: Reymund, sorry I didn't get this posted in time to save all that effort on your part - I had to change the way I did a few other...

Guys, thanks so much for the input... Reymund especially, I deeply appreciate the time and effort you've put into helping me out.

In the end I decided it was going to...

Thanks very much for the input Reymund - it's really appreciated.

I did the first part ok (inserting the result of the grouped query into a new table) but the 2nd...