>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

What I had to do because goofball named a field 'number' was:

Select "NUMBER", field2, ... from TableName ...

You have to use all caps and enclose in "full quotes".

I think the best solution (read: this is what I did) is to create a view on this table that duplicates the structure in every way except rename the "NUMBER" field to something else. Then use the ViewName in all your selects and everything will work as usual.