How about:

SELECT * FROM yourtable WHERE RecNo() = RecCount()

>Is there a way to select the last record of a table with only a select statement?