[AccessD] select most recent

Okay, I built tblTest.  It has ManagerID, TerritoryID and DateAssigned as
you have below.  Then I used this SQL statement to produce the results you
want:
 
Select ManagerID, TerritoryID, DateAssigned