Show latest dates only

[David Ball]

Hi,

If I have a report Grouped by a particular field (called KPI) and then Sorted by Date (delivery date) can I show only the latest delivery date for each KPI?

How would I do this?

Thanks very much

Dave

 

[Eljefegeneo]

I may be getting in over my head with this advice, but I had almost the same situation, although I think mine was much more complicated as I needed sales totals and some other fields which resulted in about four or five queries combined to get a desired result.

I selected the ClientID and then the dates of contact [DateOfContact] and then wanted the last date. So I used the following query:

SELECT tblSalesContactsFinal.ClientID, Max(tblSalesContactsFinal.DateOfContact) AS MaxOfDateOfContact
FROM tblSalesContactsFinal
GROUP BY tblSalesContactsFinal.ClientID;

Basically I wanted the Max of the contact date.

Try something like this and see if it gets you on the way. Substitute your [KPI] for my [ClientID] and your [delivery date] for my [DateOfContact].