Hi Jay,

This is an interesting one as you can't search on Age at Death. I think
Age of Death is something that is calculated when called rather than
being stored in the database.

Use the Name List Print where you can add Age at Death to the data to be
included.
Include at least RIN, Name of person, Age at Death.
Save as a csv
Open the csv in a spreadsheet like Excel.
Then sort the Age at Death column.
There's your people who have died at 100 or more.

However this isn't going to find people still alive who are over 100.

To find them, you'll also be finding people for whom you haven't a death
date.

On a copy of your database, you could use Advanced Set Living changing
the age at which to presume dead to 100 - and get the list of people
changed.

Note I say a copy as you don't want to be marking dead people who are
still alive.

This tool picks up a mix of people including those with no dates whose
surrounding relatives show they must be dead and those with a birth date
that would make them 100 but who don't have a death date. It would be a
good idea to run this at your normal cut off age first to limit the list
to those more possibly in  your target group. The default is 120. I
usually lower this slightly but not down to 100.

To get some but not all, there is the new Family File Statistics Tool

Perhaps you'd like to put in a request for something easier.

Cathy

> Jay 1FamilyTree <mailto:[email protected]>
> Sunday, 25 May 2014 8:22 AM
> How can I create a report of persons who lived past 100?
>
> I am hoping someone may already have created one.
>
> Thanks in advance for any help
>
> Jay
>



Legacy User Group guidelines:
http://www.LegacyFamilyTree.com/Etiquette.asp
Archived messages after Nov. 21 2009:
http://www.mail-archive.com/[email protected]/
Archived messages from old mail server - before Nov. 21 2009:
http://www.mail-archive.com/[email protected]/
Online technical support: http://www.LegacyFamilyTree.com/Help.asp
Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our 
blog (http://news.LegacyFamilyTree.com).
To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp


Reply via email to