Latest Date for Each Person

[music_al]

I have a Patient Table linked to an Appointment table.

Each patient can have many appointments and all patients SHOULD HAVE a planned appointment in the future (but some dont).

I need a query that will return the patients that do not have a future planned appointment date and to only show their last appointment date.

Thank you in advance.


Al

 

[Alansidman]

Look at the attached. Does this solve your issue?

 

[music_al]

thank you so much Alan - that worked great