Report that shows only the most recent records

[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

 

[Chris]

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

 

[Tom Snider-Lotz]

It took a little tweaking, but it works!

Thanks, Chris