>>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 :)


It's all in how you look at it. It worked like that for 15 years?1!##@%@$ Gives me a sick feeling in my stomach. What other timebombs are there? ;)


>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....

:)