I am trying to figure out just what you are asking for but it looks like a guessing to me! Based on the original question I see several correct answers!
You asked:
1.) obtain the last record - by appointment date.
2.)for a particular record(Client)
Your question has been answered.
If you are looking for something else than what you asked for then we need more specifics.
What is it that you are looking for?
1). The last record - by appointment date for a particular record(Client)?
2). A recordset based on the above for all clients, returning only the last record for each client?
3). A recordset based on the above for all clients, returning all records for all clients but displaying the last record for each client first?