Thanks! I knew about that, and it does get a lot of them, but it didn't get a woman who married a man born in 1857, nor the no-dates sister of man born in 1784 and married to a no-dates husband. Besides, one might want to use a sliding scale, e.g. 16th century no-dates don't live to 100, but 20th century do. One can use Microsoft Access to do sophisticated things in Legacy, such as the above. A beginning on the query is: SELECT tblIR.Living, tblIR.Surname, tblIR.GivenName, tblMR.HusbBirthSD, tblMR.WifeGivenName, tblMR.WifeSurname, tblMR.WifeBirthSD, tblIR.DeathSD FROM tblMR INNER JOIN tblIR ON tblMR.IDIRWife = tblIR.IDIR WHERE (((tblIR.Living)=0)); but this does only spouses, and lacks a less-than test date for either husband or wife birthdates, e.g. 1900. Jonathan
Legacy User Group guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
