>Naomi,
>>
>>I do not see a difference with my current code in this one. The saving of recno is important since SUM changes record pointer.
>
>the second Select - after SQL-Select you cannot be certain the alias is the one you want.
>And since you didn't reposition to recno in the code *shown* it was questionable <bg>.
>
>Have you run the testing code from my other post ?
No, sorry, I was not working today. May be would do at night.
If it's not broken, fix it until it is.
My Blog