Display only last record in a certain table

[whoisit]

With this query i would like only to display the last record in a certain table. How would i do that.
I have tried to use the totals to show the last record but it doesn't work because i have calculations in my query. Any suggestions
THANK YOU

 

[trucktime]

Last record

Try this:

Suppose you have an ID field (Autonumber) in the query which is based on the table.
In the grid, sort that field descending.
Then go to the query properties and set Top Values to 1

 

[whoisit]

Thanks a lot for the replies
Trucktime your suggestion worked so thank you

 

[trucktime]

Great

You're welcome.