>Hi Ashley
>
>>The routine seems to have worked just fine for 15+ years...
>
>Why do people keep saying say that? Just because something worked for years does not mean it is intrinsically right. Asbestos insulation seemed to work just fine for years. :) To me, software is - to paraphrase Khan - bugs concealed.
>
>By the way, including aliases in the index is not required unless the index spans two tables. It's recommended not to put aliases in the index expression, nor to have them span two aliases.

Hi Mike,

'Coz it gives me (...and maybe them) a warm, fuzzy feeling :)
What I was really trying to say was that, right or wrong, for 15+ years it gave a very accurate impression of working impressively accurately...
The index did include two tables and was temporary; it existed just for the lifespan of the report.
I have since seen the error of my ways....