Queries – Page 2 – Family Historian User Group

Sub Categories

England and Wales GRO Birth Index 1984-2000: This query lists all the Individuals that should appear in the ‘England and Wales, Civil Registration Birth Index 1984-2000’ based on the Date & Place held in the Birth event
England and Wales GRO Death Index 1984-2002: This query will list all the Individuals that should appear in the ‘England and Wales, Civil Registration Death Index 1984-2002’ based on the values held in the Date & Place in the Death event
England and Wales GRO Marriage Index 1984-2000: This query lists all Individuals who should appear in the ‘England and Wales, Civil Registration Marriage Index 1984-2000’ based on the Date & Place held against the first Marriage for a couple
Export FH to Access: Produces basic details on all individuals
Facts Linked to a Source: A list of Facts (Events or Attributes) linked to a specified Source, provided that the Source is one of the first six Citations for a Fact
Facts with Undefined Type: Lists all facts, where the fact type is not included in any active Fact set
Families Common to 3 Named Lists: Returns families who occur in each of 3 specified pre-populated Named Lists, that are prompted for on running the query
Families with a Child of a Specified Name: Returns families who have a child with a specified given name, which is prompted for on running the query
Family Group Sheet: Lists the people who are descendants (1 generation) or spouse of a selected person, and provides the basis for a Family Group Sheet, but does not contain all the columns
Family List by Record ID: Lists all Families on file by the Family Record ID, showing Husband, Wife, Marriage Date & Place, number of Children attached to the family, and Automated and Custom ID’s
Female Lines with Generation Numbers: Gives all descendants of a selected woman who has an exclusively maternal line, for example for DNA testing preparation
Find Distant Relations: Asks for two people and gives a list of anyone who has a relationship with both of them (including via spouses)
Find Individuals with Notes: Find all People with Notes: May be used to create a Named List from the Query, then you can delete People from this List as you action the Notes
Find Individuals with Similar Names: This simple query produces a list of all people whose first and last names begin the same way
Flag Living: This query attempts to flag all persons living in a file
How Related – Between 2 Individuals: “How Related” is a query that gives the relationship(s) between two selected individuals (“Starting Person” and “Ending Person”)
Individual Fact Citations: This Fact Query lists Citation details for Sources linked to the Facts (Individual and Family) owned by the specified Individual
Individual Timeline plus Historical Facts: This query prompts for a Key Individual and lists Facts (Events and Attributes) relevant to that person’s life
Individual Timeline plus Historical Sentences: This query prompts for a Key Individual and lists Facts Narratiove Sentences (Events and Attributes) relevant to that person’s life
Individuals updated in recent days: Simple query which prompts for a number of days and then lists only records updated in the period for the days entered
Kinsfolk Census Done Table: This query evolved from the earlier Census – The Missing Years download
Kinsfolk Census To Do Table: This query evolved from the earlier Census – The Missing Years download
Line of Ascent: The query will list the direct line of ascent from the “Starting Person” to the “Ending Person”
Line of Descent: The query will list the direct line of descent from the “Starting Person” to the “Ending Person”
Linked Individuals: Returns a person of interest together with all of the people connected to them
List Baptisms and Burials for Places: This a Fact Query which lists Baptisms and Burials in the current file relating to a specified Place, sorted by Fact and then in ascending Date order
List Single Relation Pool: Prompts for a Relation Pool number and lists all members of that pool
Living in List: Simple Query which lists everyone in a Named List called “Living”, that can be used in conjunction with the Split Tree function
Living List: Can be used to load the Individual Records Window with a column of tick boxes for a “Living” Named List
Living List Create: Query to attempt to identify all living people, that can be used to create a “Living” Named List
Location: Shows the Date and Place of Birth plus the Date and Place of Death locations for every person
Male Lines: This Query selects only male descendants of a male start person
Marriage Not Found: This Query displays: Individuals with a specific surname Individuals who have no marriage recorded Probable earliest marriage date (say 15 yrs after birth) Probable latest marriage date (say 60 yrs of age) Census place (if known) for nearest census before earliest marriage date and for each census year up to latest marriage date It excludes: […]
Married Cousins and Other Relationships: Family Query which lists Families where the Husband and Wife have a second relationship
Married Women: List of Married Women by married name with Date of Birth and Marriage
Married Women Names: List of Married Women by married name with Date of Birth and Marriage
Media Linked to a Record: Lists all Multimedia linked to a selected Record, which can be any Record Type and is prompted for
Missing Certificates – Ancestors: This Query shows the Birth, Marriage, Death and source information of all the Ancestors of a selected person
Missing Statutory Birth Certificate: A checklist to identify individuals where birth dates are not fully recorded (estimates, ranges, etc), and may indicate certificates still to be sourced
Missing Statutory Death Certificate: A checklist to identify individuals where death dates are not fully recorded (estimates, ranges, etc), and may indicate certificates still to be sourced
Missing Statutory Marriage Certificate: A checklist to identify individuals where marriage dates are not fully recorded (estimates, ranges, etc), and may indicate certificates still to be sourced
More Than One Parental Family: Query to identify possible duplicate individuals through their children
Most Recent Common Ancestors: This Query asks you to select 2 people and the Result Set should include the originally selected people and their most recent common ancestors
Name Search: This Query is designed predominantly for finding women, as it searches by Surname and “contained in” Given Names, but includes women who match the pattern, by the fact that one of the first 5 husbands had that Surname
Name Search with Dates: This Query is designed predominately for finding women, as it searches by Surname and “contained in” Given Names or Nick Name, but includes women who match the pattern, by the fact that one of the first 5 husbands had that Surname
Nicknames: Identifies all people with Nicknames – for use when the first Given Name cannot be recalled
No Family As Child (Orphan?): Find all people without a “family as child” i
Occupations: Query selects all people with one or more Occupations sorted by name
Occupations List: Displays Occupation information recorded for Individuals
ONS – [given] born in [place]: One-Name Study query selecting Individuals by their place of birth