I don't understand if you use Sql Server or VFP (Sql server not suport into table and VFP not support Var=SubQuery, i check it with VFP 6)

If this is with VFP, the first sql must work, simply add the adrres&max date fields in Order and group by. Is a basic rule of groupping... Only adding the adrees never work