Ha ha. You guys aren't gonna let me give up are ya! 😛

There is no real limit to the number of sub assemblies, but I would be confident to say...

I might have to bail out on this one! 🙁

Even if this did exactly what I wanted, I wouldn't be able to administer it because I just 'don't get it'...

Thanks for taking the time to have a closer look.

When I use your code I get an error:

"Error 208: Invalid object name 'expand'"

Any ideas?

My apologies Greg. I'd made my earlier example simpler and forgot to amend on my second post.

I seem to have caused quite a fuss with this post! I dunno if...

Greg Snidow (10/30/2007)

---

Andy, you might get some help if you posted table structure and sample data, including create and insert statements, and a sample of what you want the results...