Vlad
It makes no sense to me either.
It appears to be a connection between having a field named 'number' and and SQL somehow picking up the recno of another record. I did not reference recno() in my original SQL at all.
You may like to try for yourself, set up a simple table called test with fields number, name. Enter data 1,2,4...Bill,Tom,Vlad. SELECT number FROM test WHERE number = 3. Does this bring back record 4 Vlad - if so why ? .... Vlad's number is 4 ?
Anyway it doesn't matter, as soon as you change the name of that key field to something else it works........
It's all good fun
Glenn
>To be fair, it doesn't make sense. :) I mean: it shouldn't work like this. I understood you select the RECNO() as a field in the result.
>
>Vlad
Glenn
DOE(NI), Belfast