>>Dan,
>>
>>Thanks to you and Nigel. I think I will do just that.
>>
>
>Yeah, I just saw his post, and would have done the other by doing a select sum as a secondary alias, but didnt know the complexity of your "other function" doing the work. But, yes, if it is a simple SUM(), I would just combine with mine and Nigel's options.
>
>
>Don
The funny thing is that I'm still getting the error after I've done that. And something else is still not right...
The problem is that the indexes are not structured and I'm not sure if it's possible to use INDEX command opening the table twice under different aliases...
If it's not broken, fix it until it is.
My Blog