Thanks for all your help Sergey. I'm sorry for the delay in my reply but have been unabled to login into UT for several days.

BTW, I'm still having problem with the parent account totals but I think it's the data. This data was imported into SQL server from a VFP application.

Thanks again!

>There can be only one ORDER BY clause per UNION at the end of select. It applies to the whole result set. Sorry about that.
>Try to get each select to work separatelly and then join them with UNION ALL and change ORDER BY to

...
>Order By 1

>
>>I'm gettin an invalid Union clause error message. If I delete the order by in the first select then I get another error message stating there must be a order by element.
>>
>>