easier if you can add an AutoNumber field to your table.
you can then query the Max() of this field to get the latest name.
eg, ID here is the AutoNumber field:
SELECT T1.MaxOfID AS ID, T1.nameField, yourTable.otherField1, yourTable.otherField2, yourTable.otherField3 FROM (SELECT Max(yourTable.ID) AS MaxOfID, yourTable.nameField
FROM yourTable
GROUP BY yourTable.nameField) T1 INNER JOIN yourTable ON T1.MaxOfID=table2.ID;