On Sun, 21 Nov 2010 10:56:01 -0800 (PST), Ron Taylor <[email protected]> wrote:
>True, potential problems shows those marriages but they are mixed with many >others that do have a spouse with a RIN and are therefore "problems" because >of the age of one or both of the spouses. But if you mark these as "not a problem", then they won't show up in future reports, leaving only new problems that have been added recently. >I would like to locate just those children who have no offspring and have a >spouse without a RIN. I'm sure you will tell me this is not what you meant, but... SELECT tblMR.IDMR, tblMR.IDIRHusb, tblMR.HusbGivenName, tblMR.HusbSurname, tblMR.IDIRWife, tblMR.WifeGivenName, tblMR.WifeSurname FROM tblCR RIGHT JOIN tblMR ON tblCR.IDMR = tblMR.IDMR WHERE ((tblMR.IDMR<>0) AND (tblMR.IDIRHusb=0 OR tblMR.IDIRWife=0) AND (tblCR.IDCR Is Null)) -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
