I have a table in an access database that contains records for members. Each member has several records for each payment they have made over the years.

I would like to create a filter that shows only the record of the most recent payment date for each member.

Pretty new to Access so am a bit lost.

TIA,

emr