show last date in a report

S

sheryl

How can I show the "last" date of a record in a report? There are many
entries for one establishment, but I only want to show the last date per
establishment.
Can I do this in a report, or a query to a report? Gracias!
 
A

Allen Browne

Open the query that feeds your report in design view.
Try typing something like this into the Field row of the query:

LastDate: (SELECT Max(TheDateField) FROM MyDetailTable
WHERE MyDetailTable.EstablishmentID = MyMainTable.EstablishmentID)

If you can get that working, it will probably be the most efficent approach.
 
Top