you have a couple choices:

SQL like this:
select * from orders where orderdate in (select max(orderdate) from orders)

Or just open your recordset, sorted by date descending, and just display the first record