>For a report (i.e., R/O), you could put the result (in the wrong order) into a cursor, and then SELECT from that cursor into a second cursor.
>
>Another option is to create a temporary index.
>
>I don't know a way to do it with just one SELECT command.
This is with OleDb, so I need to find a way to have this using one SQL. One way I have thought would be to select with the default order, thus ascending, go at the end, skip -5, get the date and do another SQL with the DESC order having a condition on the date to get only the five records I want.