Hi Kevin

If you are just selecting data from a single table and you want the latest dates first, the command would be something like:

select date,field2,field3 from table1 order by date ascending


If you only require a certain number of records you can use the TOP option.


HTH
K