Hi, I am slowly getting used to doing queries, please could anyone tell me is there a way to do one for a person who died as a child or before they got married.
Any help appreciated, thanks
Marilyn
ID:4386
* People who died as children
-
Jane
- Site Admin
- Posts: 8441
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
People who died as children
Yes.
Oh you mean you want to know how? [grin]
The died as child is easy enough
Add if =AgeAt(%INDI%,%INDI.DEAT.DATE) less than 21
You could also use %INDI.DEAT[1].DATE:AGE_AT% but that will only return if you have in keyed (I think)
Unmarried people
Find everyone who is not married
Add if %INDI.FAMS[1]>% is null
Then exclude the living (or at least not known as dead)
Exclude if %INDI.DEAT% is null
Oh you mean you want to know how? [grin]
The died as child is easy enough
Add if =AgeAt(%INDI%,%INDI.DEAT.DATE) less than 21
You could also use %INDI.DEAT[1].DATE:AGE_AT% but that will only return if you have in keyed (I think)
Unmarried people
Find everyone who is not married
Add if %INDI.FAMS[1]>% is null
Then exclude the living (or at least not known as dead)
Exclude if %INDI.DEAT% is null
People who died as children
Yes, I did want to know,lol, just worded it wrong, thanks for your help Jane, off to work now but I will try that out tomorrow.
Feeling quite pleased with myself, managed to get flags on diagrams for birth marriage and death certificates obtained, great stuff!![grin]
Marilyn
Feeling quite pleased with myself, managed to get flags on diagrams for birth marriage and death certificates obtained, great stuff!![grin]
Marilyn
-
PeterR
- Megastar
- Posts: 1129
- Joined: 10 Jul 2006 16:55
- Family Historian: V7
- Location: Northumberland, UK
People who died as children
There is more than one way to skin a cat, so here's my contribution:
Columns
Individual %INDI%
Birth %INDI.BIRT[1].DATE%
Death %INDI.DEAT[1].DATE%
Death Age %INDI.DEAT[1].AGE% [if explicitly entered]
Death Date(Age_At) %INDI.DEAT[1].DATE:AGE_AT%
=AgeAt(Death) =AgeAt(%INDI%,%INDI.DEAT.DATE%)
Latest est.Birth =EstimatedBirthDate(%INDI%,LATEST,2)
Earliest est.Death =EstimatedDeathDate(%INDI%,EARLIEST,2)
Min.est.Age =EstimatedAgeAt(%INDI%,EstimatedDeathDate(%INDI%,EARLIEST,2),MIN,2)
The last three columns may be useful if you have baptism and/or burial dates rather than birth and/or death dates.
Rows
(1) Add unless %INDI.DEAT[1]% is null
(2) Add unless %INDI.BURI[1]% is null
(3) Add unless %INDI.CREM[1]% is null
(4) Exclude if %INDI.DEAT[1].AGE% is older than ['Age']
(5) Exclude if %INDI.DEAT[1].DATE:AGE_AT% was later than ['Age']
(6) Exclude if =AgeAt(%INDI%,%INDI.DEAT.DATE%) is greater than ['Age']
(7) Exclude unless %INDI.FAMS[1]>% is null
Filters 1-3 will include anyone where any death-related event exists. Filter 4 then excludes those where explicitly recorded age at death is older than the cut-off age you specify, e.g. 15 (above which age they could have married) or 20 (i.e. 21 or older). Filters 5 & 6 exclude on the basis of an age calculated from birth and death dates; I've used both because they don't always give the same result for non-exact dates. Filter 7 excludes anyone linked as spouse to a Family record, even if technically unmarried.
Columns
Individual %INDI%
Birth %INDI.BIRT[1].DATE%
Death %INDI.DEAT[1].DATE%
Death Age %INDI.DEAT[1].AGE% [if explicitly entered]
Death Date(Age_At) %INDI.DEAT[1].DATE:AGE_AT%
=AgeAt(Death) =AgeAt(%INDI%,%INDI.DEAT.DATE%)
Latest est.Birth =EstimatedBirthDate(%INDI%,LATEST,2)
Earliest est.Death =EstimatedDeathDate(%INDI%,EARLIEST,2)
Min.est.Age =EstimatedAgeAt(%INDI%,EstimatedDeathDate(%INDI%,EARLIEST,2),MIN,2)
The last three columns may be useful if you have baptism and/or burial dates rather than birth and/or death dates.
Rows
(1) Add unless %INDI.DEAT[1]% is null
(2) Add unless %INDI.BURI[1]% is null
(3) Add unless %INDI.CREM[1]% is null
(4) Exclude if %INDI.DEAT[1].AGE% is older than ['Age']
(5) Exclude if %INDI.DEAT[1].DATE:AGE_AT% was later than ['Age']
(6) Exclude if =AgeAt(%INDI%,%INDI.DEAT.DATE%) is greater than ['Age']
(7) Exclude unless %INDI.FAMS[1]>% is null
Filters 1-3 will include anyone where any death-related event exists. Filter 4 then excludes those where explicitly recorded age at death is older than the cut-off age you specify, e.g. 15 (above which age they could have married) or 20 (i.e. 21 or older). Filters 5 & 6 exclude on the basis of an age calculated from birth and death dates; I've used both because they don't always give the same result for non-exact dates. Filter 7 excludes anyone linked as spouse to a Family record, even if technically unmarried.
People who died as children
You could also simply use the standard age at death query & click on the age column to sort by age. Copy & paste the young ones into excel.
People who died as children
Thanks for your help, will try your suggestions.
Marilyn
Marilyn
People who died as children
Just for interest, on the subject of flags and those who died young. I made a little black cross icon to flag people who died young on diagrams. Its quite useful and shows how terribly unlucky (or lucky) some families were.
Anne
Anne