Bernard, Reading between the lines I believe you are talking about a Query and its Result Set rather than a Report. The tactic to adopt involves the function =IsAncestorOf() to determine which Spouse is the Ancestor of your starting person. Then the function =TextIf() to only show the Marriage Date of the matching Family Event. Then the function =Text() to join these alternatives together. This 1st expression will only show the 1st Marriage Date if the 1st Spouse is an Ancestor of FileRoot(). =TextIf( IsAncestorOf( %INDI.~SPOU[1]>%, FileRoot() ), %INDI.FAMS[1]>MARR[1].DATE:COMPACT%, ) This 2nd expression will only show the 2nd Marriage Date if the 2nd Spouse is an Ancestor of FileRoot(). =TextIf( IsAncestorOf( %INDI.~SPOU[2]>%, FileRoot() ), %INDI.FAMS[2]>MARR[1].DATE:COMPACT%, ) This 3rd expression will only show the 3rd Marriage Date if the 3rd Spouse is an Ancestor of FileRoot(). =TextIf( IsAncestorOf( %INDI.~SPOU[3]>%, FileRoot() ), %INDI.FAMS[3]>MARR[1].DATE:COMPACT%, ) Only one of the above will yield a Marriage Date and the others empty strings. =Text( TextIf( IsAncestorOf( %INDI.~SPOU[1]>%, FileRoot() ), %INDI.FAMS[1]>MARR[1].DATE:COMPACT%, ) . TextIf( IsAncestorOf( %INDI.~SPOU[2]>%, FileRoot() ), %INDI.FAMS[2]>MARR[1].DATE:COMPACT%, ) . TextIf( IsAncestorOf( %INDI.~SPOU[3]>%, FileRoot() ), %INDI.FAMS[3]>MARR[1].DATE:COMPACT%, ) ) Extend as necessary if more than 3 marriages involved. Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Bernard Sharp Sent: 12 February 2012 15:46 To: Family Historian Users Subject: [FHU] Ancestors' Report Query I have created a report to list all the ancestors of a specified ‘starting person’, in ascending Ahnentafel Number sequence, recording for each ancestor, the dates of their significant life events, e.g. birth, baptism, marriage, etc., together with a test (by means of the ‘text if exists’ conditional function) for the presence of the respective multimedia item for each event. The foregoing works o.k. except for multiple marriages. Irrespective of how many times a groom has married, the report always returns the date of the first marriage, the default expression for a marriage date being ‘%INDI.FAMS[1]>MARR[1].DATE:COMPACT%’. This is o.k. should the groom’s first bride be the starting person’s direct ancestor, but not if she is the 2nd, 3rd, etc. The default marriage date expression can be modified to return either the 1st or 2nd or 3rd, etc., but this is fixed, whereas the ancestor’s marriage could be any of them, dependent on which wife is the starting person’s direct ancestor. I am at a loss as to how to automatically return the correct marriage date for the groom. I have consulted the FHUG knowledge database but to no avail. Perhaps someone with technical expertise could help me.