Getting last three records

[Jennifer]

I need help with code to retrieve the last three records from a long database table.
I know how to use =Last function , but am unable to retrieve previous two records. Thank you Jennifer

 

[KevinM]

Create a query based on the table in question. Change the sort order to Descending so it showing the most recent (Last) records at the top. In the query's properties box change the 'Top Values' line to 3. It will now always display the last 3 records. You can base your report on this query.

HTH

Kevin M