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