I managed to do it indirectly using a mixture of an FH query and Excel.
I started out with a query with columns for Individual,
INDI.NAME:GIVEN_ALL and INDI.FAMC>HUSB>FAMC>HUSB>NAME:GIVEN_ALL
and a row filter to include individuals with Sex = Male. This gives all of
the forenames of the men and their grandfathers. I then copied all of the
cells and pasted them into Excel. I then added a fourth column containing
the formula =IF(Bx=Cx,"Same",""), where x is the number. This puts the
Same in the fourth columns of those rows where the man has the same name as
his grandfather. I then filtered the table for rows containing "Same" in the
I hope that isn't too cryptic! It does the job and shows me that this naming
pattern is quite unusual in my family.
----- Original Message -----
From: "Jane Taubman" <janetaubman(a)gmail.com>
Sent: Saturday, March 24, 2007 8:43 PM
Subject: Re: [FHU] Same first name
On 24/03/07, John Marquess <HighestPub(a)btinternet.com> wrote:
I am trying to construct a query to process every male in my tree in
to list individuals who share the same First name as their paternal
grandfather. e.g. where the grandfather of Fred Bloggs was also Fred
The real limitation is that I don't think you can compare two
The expression to get the grandfathers name is
The only suggestion I can come up with is to build the list and sort
by first names to group the matching ones together.
Or perhaps add a selection by name to say Search for all the Georges.
Family Historian Users List Moderator
Family Historian User Group Site Web Master
To unsubscribe from the list, please send an email to
FAMILY-HISTORIAN-USERS-request(a)rootsweb.com with the word 'unsubscribe'
without the quotes in the subject and the body of the message
This email has been verified as Virus free
Virus Protection and more available at http://www.plus.net