I'd like my report to display only the data associated with the most recent date.  I've sorted by the date field so that most recent appears at the top for each record but can't see any option for "most recent" in the select expert.

 

Is there a simple formula for this?

 

Thanks a lot.

 

 

 

 

Thanks Emir,

 

 

I tried this without success but it put me on right track.  I was able to use @ maximum in the group summary field. 

 

Thanks  a lot

 

Lynne