Limiting the results on access database

1

Okay i found out that msaccess doesnt support LIMIT in it’s SQL statements. How would I go about only getting one record from a SELECT statement? :-/