>Sergey/Cetin
>
>>I agree with Cetin, it cannot be done with one query w/o subqueries.
>
>I'd kinda come to that conclusion myself last week after tearing my hair out for 2 days. I was just hoping that soemone more au fait with (basic) SQL might have an idea. I think I'll need to do it in code with do loops. What a pain!
>
>Thanks again for your efforts and trouble
>
>Terry

In code? You have chance to code with do loops? Then create a temp table for MB?
Cetin