SELECT *, (SELECT F+' '+I FROM Members WHERE Members.ID=SchoolMembers.Member_id) as Name,

(SELECT MAX(Date) FROM AdviceToSpeeches WHERE AdviceToSpeeches.member_id=SchoolMembers.Member_id)
as LastDate
FROM SchoolMembers
WHERE Reci Like '%1%'

ORDER BY LastDate - ????