how to make a report using just the last record

[jlcastrejon]

Hi everybody,
Could someone tell me how to make a report using just the last record of my access 2007 database?
Tks.
Jose

[NeoPa]

That all depends on what you mean by last really doesn't it.

You would create a query for the report to use which is sorted in reverse order and use the TOP predicate of the SELECT clause :

SELECT   TOP 1 *
FROM     YourTable
ORDER BY YourSortField DESC