Hello and thank you in advance for any attention this post may receive.
Table = tblUnit
Result table column = "Make"
Criteria table columns = "ID_Unit" and "Date_Commissioned"
Criteria = ID_Unit = txtUnit value and Max(Date_Commissioned)
My desired result is to return (in txtMake) the Make of...