* Query to list immediate ancestors

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
Post Reply
User avatar
rodit
Famous
Posts: 228
Joined: 02 Feb 2008 02:39
Family Historian: V7
Location: Wollongong, New South Wales, Australia

Query to list immediate ancestors

Post by rodit » 17 Jan 2018 04:32

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

User avatar
BillH
Megastar
Posts: 2179
Joined: 31 May 2010 03:40
Family Historian: V7
Location: Washington State, USA

Re: Query to list immediate ancestors

Post by BillH » 17 Jan 2018 04:35

Roger,

There is a standard query called Ancestors. Is that what you are looking for?

avatar
Gowermick
Megastar
Posts: 1629
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Query to list immediate ancestors

Post by Gowermick » 17 Jan 2018 17:22

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]
Mike Loney

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
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

Post by rodit » 18 Jan 2018 01:41

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

Post Reply