Report that shows only the most recent records

  • Thread starter Thread starter Tom Snider-Lotz
  • Start date Start date
T

Tom Snider-Lotz

I've got a database that I use to keep track of events in the life cycl
of several products. The main table has fields for EventNumbe
(autonumber/key), Date, Product, and EventDescription. So each recor
corresponds to an event.

It's easy to generate a report that lists _all_ the events in the lif
of each product. What I'd like now is a report that lists only th
most recent event for each product -- basically a status report.

How do I do this?

Thanks in advance.

-- To
 
You need to base your report on a pair of queries

Qry1:
Select Product, max(EventDate) as LastDate From tblEvents
Group by Product

Qry 2:
Select * from tblEvents inner join Qry1 on
tblEvents.Product = Qry1.Product and
tblEvents.EventDate = Qry1.LastDate

Base your report on Qry2
 
Back
Top