show last date in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Back
Top