Most Recent Dates of Service Containing Specified Criteria - Microsoft Community

this seems should simple, cannot seem make happen. becomes 2-part issue.

i have table of unique patients (names, account numbers, etc.) and table of office visits includes name, account number, date of service, , cpt code (code identifying type of visit).

the goal generate list of unique patients column containing recent date of service specific cpt, if have had one. if have not had date of service specified cpt, want patients' names still on list , either blank or contain text such "none".

i can create query of with given cpt, but it return multiple visits (rows) 1 patient, rather recent. list excludes has not had specified visit type.

i have created few sample rows fake information sake of example:

patientt

officevisitt

goal: replicate "patientt" additional column for the recent dos patients had 99213. jerry wilson, cell in column blank or "none".  

don't have patient id in officevisitt? lastname, firstname, dob, , act # should not in officevisitt. can assume dos date of service?

i think can use subquery pull maximum dos each patient.

Office / Access / Windows 10 / Office 2010