the recno and recount are not options but i just did a select in the end with an inverted order and looped through the first 10.
Slán
~M

>>hi all
>>i am trying to select out the last 10 records entered by a user in a table. the db is foxpro and the code is called from an asp page. anything i try like "DESC LIMIT 3", LIMIT, is not working, any ideas?
>>Slán
>>~M
>Hi Mark
>
>If you meant, by SQL-select.. You can try .."where recno() =< reccount()-10" on its option..
>
>
>HTH
>
>Claudio