>Boy Shane, your scenario is definitely no joy in fox's implementation of SQL. This isn't exactly graceful, but here's how you could get it to work.
>Like I said... no joy. Maybe somebody else can look at this and pipe up a better way. HTH.
I had hoped it would be easier, but I guess not. Thanks for all your help. I'll let you know what I end up with.
Shane
--Shane