Selecting most recent date record.

[Solofish1]

I have a membership based database which has multiple records per person in the fees paid section. I wish to be able to select the most recent fee record regardless of the year. Screen shots are attached of both a sample of the fee records per person and the sql coding.

[Welshgasman]

Look at the Max() function

[orange]

Finding most recent Date is quite a common request. See the links in Similar Threads at the bottom of this page.
There is an example by PBaldy here.