Hi there,

I have a table that contains several records per person per day, as:
name,datetime,blabla
joe,2003-10.31-08.00,test1
joe,2003-10.31-09.00,test2
joe,2003-10.31-10.00,test3
joe,2003-10.31-11.00,test4
joe,2003-10.31-12.00,test5
etc

I want to retrieve the last 4 things joe has done, ordered by datetime (asc).

So using FIRST 4 and use 'desc' order is not ok... :-(

How can I do that (using FB1.03)?

regards,
Yves