Paul, you can use a query to extract just the last record, assuming the records are dated or numbered.
You can use Max of or you can use Number of records where n = 1.