I am trying to identify a list of office patients who have a specific diagnosis along with their most recent office visit date (s). So for example, I want to create a list of all my Hypertensive patients and their last office visit. Or all my obese patients and their last office visit.

Can this be done? How?