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
* Query to list immediate ancestors
- BillH
- Megastar
- Posts: 2179
- Joined: 31 May 2010 03:40
- Family Historian: V7
- Location: Washington State, USA
Re: Query to list immediate ancestors
Roger,
There is a standard query called Ancestors. Is that what you are looking for?
There is a standard query called Ancestors. Is that what you are looking for?
Re: Query to list immediate ancestors
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]
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]
Mike Loney
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- rodit
- Famous
- Posts: 228
- Joined: 02 Feb 2008 02:39
- Family Historian: V7
- Location: Wollongong, New South Wales, Australia
Re: Query to list immediate ancestors
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
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