This one could be fun. 1) Clear tag1 2) use Legacy>Search>Find>Miscellaneous>Linked individuals with no parents then click "Clear List before this search" and click "Create List". When then search results list is displayed, click Options>Advanced Tagging>Tag and make changes to tag1. Click Everyone in Search List. Now all individuals without parents have tag1. 3) Create and save the following query which will be used in step4. Name it qtblMR_parents_eol
SELECT DISTINCT tblCR.IDMR FROM ((tblCR INNER JOIN tblMR ON tblCR.IDMR=tblMR.IDMR) INNER JOIN tblIR ON tblMR.IDIRHusb=tblIR.IDIR) INNER JOIN tblIR AS tblIR_1 ON tblMR.IDIRWife=tblIR_1.IDIR WHERE (((tblCR.IDMR)>0) AND ((tblIR.Tag1)>0) AND ((tblIR_1.Tag1)>0) AND ((tblMR.IDIRHusb)>0) AND ((tblMR.IDIRWife)>0)); 4) Run this query to find the marriage records to answer your question. SELECT tblCR.IDMR, Count(tblCR.IDIR) AS Children FROM qtblMR_parents_eol INNER JOIN tblCR ON qtblMR_parents_eol.IDMR = tblCR.IDMR GROUP BY tblCR.IDMR HAVING (((Count(tblCR.IDIR))=1)) ORDER BY tblCR.IDMR; Let me know if this is what you needed. Note you could tweak the "Having" number of children as desired. Ron Taylor On Tuesday, July 8, 2014 8:33 PM, Jay 1FamilyTree <[email protected]> wrote: I would like to create a report of all parents that only have one child AND the parents have no father or mother in my database. If any great sql coders could help me out, that would be great. Thanks Jay 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 Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp 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 Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
