How to display the most recent records

[Luong]

Hello,

I have a table with many records for a given serial#. The
different records have a date field. How do I create a
query or report to display the most recent records only
based on the most recent date field?

Thanks for your help.

 

[Janet Russell]

If I understand your question correctly, I would first
create a query containing nothing but the date field you
mentioned. I would add the total line to the query and
select "Last" from the drop down list on the total line.

Save this query, then create a new query based on both the
original table and this new query. Make sure the date
field in the original table and in the first query are
connected with a join line.

When you run this second query, only the records
containing the most recent date will be displayed.