I have a Payment file in my Access 2013 application.
The pertinent fields are
There may be many payments for each customer
There may be many payments with the same deposit date for the same customer.
I am trying to write a query that will list the most recent deposit date and payment amount on that deposit date for every client.
If there are multiple payments on the most recent deposit date, whichever payment amount, from that deposit date, that is pulled doesn't matter.
Only one line for every client.
Client Most Recent Deposit Date Payment Amount
123 10/12/17 $320.23
124 12/01/17 $12.34
125 09/13/17 $567.89