Queries – Family Historian User Group

Sub Categories

Age at Birth of First Child: Shows the age of each person at the birth of the first child of the first marriage
Age at Death Male Line: This query show the Age at Death for the Male line of a selected person
Age at Marriage V2: A version of the Age at Marriage standard query, which includes all married people with birth dates even if they do not have a date for their first marriage
Age Discrepancies: A listing of individuals with events where the age entered for the event differs from the age calculated from the birth date at the date of the event
Age Today: Simple Query which lists all people, who are alive (e
Ages on Census: This query shows the census entries you have for all individuals, except those born after 1901 or who died before 1841
Ahnentafel by Generation: Lists an individual’s ancestors, sorted according to the Ahnentafel/Kekulé numbers
Alive and Age at Date: Lists all individuals (who have birth and/or death date recorded) alive at a given date (entered via a prompt)
Alive and Age at Date with Places: Lists all Individuals who are alive at a given date (entered via a prompt)
Alive at 1841 Census: List to aid search on 1841 census
Alive at 1901 Census: List to aid search on 1901 census
All Empty Facts: Finds all Facts (Events/Attributes) without any subordinate fields
All Facts Filter by Date: A filtered list of facts – events and attributes, in the current file, in ascending date order
All Facts Filter by Label: A filtered list of facts – events and attributes, in the current file, in ascending date order
All Facts Filter by Text: A filtered list of facts (events or attributes) in the current file, in ascending date order
All Facts on Day, Month: A complete list of Facts – Events and Attributes, in the current file, for a specified day and month
All Relations and In-Laws: This query is only really a base for selecting “family” rather than relations and add a couple of generations of the spouses family to the mix for use on a split tree
Ancestors Plus Spouse and Children: Allows you select a start person and lists all ancestors plus their spouses, and their children plus their spouses
Ancestors with Age at Date: Prompts for a Root person and a year, and then shows all Ancestors of that person “probably” alive at the date selected
Ancestors’ Census Places: This Query extracts all Ancestors for a specified person, excluding those who died before 1841 or were born after 1911, and shows the Census Place for each year for which an entry has been made in the file
Ancestors’ Missing Census Entries: This Query extracts all Ancestors for a specified person, excluding those who died before 1841 or were born after 1911, and indicates for each year whether a Census entry has been entered for that Ancestor
Ancestors’ Missing Census, Sources and Images: This Query extracts all Ancestors for a specified person, and Siblings of those Ancestors, excluding those who died before 1841 or were born after 1911
Birth Details: This query has use in tidying up gaps in the data file
Blank Death Finder: Lists all people who have a Death Event which does not contain a Date or Place
BMD – Census Check: Lists all individuals in a project (plus a few other details) and any BMD entries, indicating whether an entry exists and if there is some missing information (e
BMD – Checklist: Lists the Date & Place for the Birth, Baptism, Marriage, Death & Burial of every individual
BMD – Estimated Dates: It extracts everyone where any of the BMD dates contains one of the following: (estimated) or (approx
BMD – Events without Sources: This query lists Individuals who have at least one BMD Event with no supporting Source
Born After Date and Still Living: This query seeks to identify all those individuals who were, or may have been, born after an entered Cut Off Date, and who are, are estimated to be, or who might be, still alive
Born in Place: Prompts for a text string “Place” and lists all individuals whose Birth Place contains that string
Census – Addresses 1841 to 1911: List to aid search on all census addresses
Census – Group: Displays census information recorded for a group of Individuals in a particular Year and Place
Census – Index: Displays in a single row the first four Individual Census Events found for all Individuals
Census – Place Lists 1841 to 1911: Selects only those Individuals with census records and shows the Place where they lived through the census years 1841-1911 in which they appeared
Census – Record Checklist All: Census checklist, including both Individual and Family Census Events
Census – The Missing Years: This query will list an entry for everyone who could potentially be included in a census, and if you have a census entry for that person
Check Birth Dates: Lists mothers who give birth before the age of 16 or after the age of 50 and parents (of either sex) whose children are born after their death
Citation Details: The Citation Details Query lists all Facts – Events and Attributes, in the current file showing for each Fact what has been entered under various of the Citation and Source headings that are available for the first instance only
Citation Details – Multiple: The Citations Details – Multiple Details Query lists Facts in the file for which one or more sources have been cited
Clooz Export: Creates data in the format required for Clooz to import, that is: Id, Surname, Given Name, Birth Date, Marriage Date, Death Date
Common Ancestors: Asks for two people and shows any ancestors they have in common
Contact Info: This custom Query can be used to identify all Individual Records where the Contact Info Attribute has been completed
Cousins of Named Individual: Lists Cousins of a Named Individual
Death Details: This query is useful for tidying up gaps in the data file
Descendants by Family Group: Descendants by Family Group, based on a Start person, this lists all descendants by generation
Descendants V2: Lists all the Descendants of two chosen Start Persons, ordered as for a Descendants Chart, and including life dates, spouse, father, mother, and sex
Descendants with Spouses: Simple Descendants list with their spouses
Direct Line: Allows you select two people at the start and end of a line of ancestors, and gives you all the people in that line with their spouses and children, plus their spouses
Duplicate Sources for Fact: This looks at the first seven Sources for a given Fact, but only includes a Fact in the Result Set if two of the Sources are the same
Duplicate Spouses: This Query reads through all Families comparing the first 3 spouses of each husband, and lists the Families where the man has the same spouse twice