Hi Mike, Many thanks for your further guidance and advice. I shall certainly make time to read further about creating fact queries. Regards, Bernard -----Original Message----- Message: 3 Date: Mon, 13 Feb 2012 18:33:29 -0000 From: "Beryl & Mike Tate" <post@tatewise.co.uk> Subject: Re: [FHU] Ancestors' Report Query To: <family-historian-users@rootsweb.com> Message-ID: <001601ccea7d$fbc49dc0$f34dd940$@co.uk> Content-Type: text/plain; charset="utf-8" Hi Bernard, You should be able to simply replace the %INDI.FAMS>MARR.OBJE>% data reference with the matching TextIf(Exists()) function. Remember to leave off the '=' prefix from the TextIf function. The '=' prefix must only exist on the first function in the nested set of functions. So you should get: =Text( TextIf( IsAncestorOf( %INDI.~SPOU>%, FileRoot() ), TextIf(Exists(%INDI.FAMS>MARR.OBJE>%),"Yes",""),) . TextIf( IsAncestorOf( %INDI.~SPOU[2]>%, FileRoot() ), TextIf(Exists(%INDI.FAMS[2]>MARR.OBJE>%),"Yes",""),) . TextIf( IsAncestorOf( %INDI.~SPOU[3]>%, FileRoot() ), TextIf(Exists(%INDI.FAMS[3]>MARR.OBJE>%),"Yes",""),)) If an Individual marries two genuine Ancestors of your FieRoot() then yes the function will yield two dates. For this reason, where multiple Facts of the same type are likely to arise, it is often better to use a Fact Query instead of an Individual Query. Then all the complications we have been discussing often resolve to a single expression applied to each Fact, without having to worry about multiple instances. Also when two instances satisfy your criteria (like your AN16 & 17 and AN18 & 19) then they appear on two separate rows in the Result Set, with the Owner Individual listed twice. It is quite easy in a Fact Query to reference the Owner Individual and filter them accordingly. See the FHUG Knowledge Base on Creating a Query at http://www.fhug.org.uk/wiki/doku.php?id=how_to:creating_a_query Regards, Mike Tate