That's a good suggestion...depends on whether one has just gotten a email w names of living relatives but no dates, or whether you are in a library delving into the 16th century, also w no dates. But, back to the starting query, since Legacy files are Access files, one ought to be able to write a query, or small set of queries, to find spouses with spouses with dates less than X, or children with parents with dates less than X. A not very optimal query for spouses 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)); And a not very optimal query for children is (which also contains a test date of 1875 for husbands): SELECT tblIR.Tag1, tblIR.Living, tblIR.Surname, tblIR.GivenName, tblIR.BirthSD, tblIR.DeathSD, tblMR.HusbSurname, tblMR.HusbGivenName, tblMR.HusbBirthSD, tblMR.WifeSurname, tblMR.WifeGivenName, tblMR.WifeBirthSD FROM tblIR INNER JOIN tblMR ON tblIR.IDMRParents = tblMR.IDMR WHERE (((tblIR.Living)=0) AND ((tblMR.HusbBirthSD)<18750000)); I don't know much about SQL queries, but the fun of it is finding shortcuts! 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
