Page 1 of 1
Query to list immediate ancestors
Posted: 17 Jan 2018 04:32
by rodit
I have been attempting (without much luck) to create a query which will list my Immediate ancestors, by which I mean:
Grand parents, Great Grand parents, Great Great Grandparents, etc., back as far as they go, without uncles, aunts, cousins and all the rest.
I have not been having much luck with the correct Expressions, and would greatly appreciate some help from a kind soul.
Thanks in advance.
Roger
Re: Query to list immediate ancestors
Posted: 17 Jan 2018 04:35
by BillH
Roger,
There is a standard query called Ancestors. Is that what you are looking for?
Re: Query to list immediate ancestors
Posted: 17 Jan 2018 17:22
by Gowermick
Roger,
What Bill said is correct, but it has been deliberately made flexible, so you have to choose your starting person each time.
This niggled me so I created a 2 line query to always use my tree root as follows:
1: On Rows tab General tab: Add if =IsSameItem(,FileRoot()) is true [This adds Tree Root person to resultset]
2: On Rows tab Relations tab: Add if ancestor of anyone in resultset. [This adds all direct relations of Tree Root]
[On query relations tab. Set condition=Addif, Set Relationship= Ancestor ; Set Max Generationas as required]
Re: Query to list immediate ancestors
Posted: 18 Jan 2018 01:41
by rodit
Bill and Mike, thanks
Stupid me! I missed the Ancestor query and tried to use the different Relative queries.
I have also incorporated the refinements suggested by Mike.
Thanks again. (You would think that after 10 years I would have found that).
Roger