I am so glad you were able to help her. As for me, I never set my relationships to 999, which as you say, would be ridiculous (and yes I have gotten back to medieval and earlier times). What I am most interested in is direct ascent/descent, although I find it interesting to discover the ancestral relatives.
CE ________________________________ From: LegacyUserGroup <legacyusergroup-boun...@legacyusers.com> on behalf of Cathy Pinner <genea...@gmail.com> Sent: Thursday, August 17, 2017 8:51 PM To: Legacy User Group Subject: Re: [LegacyUG] How to query in 7.5 CE Well I thought she wanted relatives. But if not, you just do it for the whole Name List. Still works. Anyway have had a private email from Patricia thanking me and that she found what she wanted. Re the Relationship settings to 999 - unless you've got very complex multiple lines of descent from multiple people - as in the royal genealogies/medieval genealogies, as I think you do, it's a waste of time to set it so high. Set relationships doesn't give you non-blood relationships beyond immediate in-laws. The Relationship Calculator does. Cathy > CE WOOD <mailto:wood...@msn.com> > Friday, 18 August 2017 1:04 AM > > Method two won't work either if you have a large file, because not > everyone in a large file is related. The poster wanted to know about > everyone in the file, not just relatives. Even though you can set > Blood relationships to 999, you can set Non-blood relationships to > only 10. > > > CE > > > ------------------------------------------------------------------------ > *From:* LegacyUserGroup <legacyusergroup-boun...@legacyusers.com> on > behalf of Cathy Pinner <genea...@gmail.com> > *Sent:* Wednesday, August 16, 2017 7:03 PM > *To:* Legacy User Group > *Subject:* Re: [LegacyUG] How to query in 7.5 > Patricia, > > There are two ways you could do it in Legacy 7.5. > 1. Customise the Index columns in Index View to include Age at Death > and then scan the column. > This obviously isn't the best way if you have a large file. > 2. Make a search list of the relevant people - eg Set Relationships to > your uncle and then search for Individual - Relationship - equal to - > Related. > Then in the Search list use Print and customise to include Age at > Death and instead of previewing or printing, use the option to save to > CSV. This file can be opened in a Spreadsheet program. There you can > sort on the Age at Death column. > > As Linda says, there are some statistics available in 8 but this isn't > in 7. > > Cathy > > Linda Yocum wrote: > Linda Yocum <mailto:yocu...@hotmail.com> > Thursday, 17 August 2017 8:38 AM > > Patricia, > > I have v8, so I hope it is the same. Go to 'Reports', 'Statistics > Report', and the 'Family File Statistics' window will open. The third > one down is 'Longest Living Individuals' listed by century. Happy > birthday to your uncle and I hope he wins! > > Linda > > > That only looks at birth year. If someone were born in 1926 and > died in 1927 they would still show up on that list, but they > aren't over 90 yrs old. > > If you look at birth year before 1927 AND death year is blank then > you'd get all the people who are still alive and 90+. It would > also pick up all those people who don't have a death date entered > yet because it isn't known. It would miss those born before 1927 > and lived 90+ years before dying. > > The person has to be born in 1926 or earlier and either still be > alive (no death date) or they died after they turned 90 (death > year minus birth year). > > Since age is a calculated amount and I don't know how to do that > in Legacy, you might have to do a separate search for: > 1) those who were born before 1927 and are still alive (death date > blank) > 2) then for each year before 1927 > birthdate before 1926 AND deathdate after 2016 > birthdate before 1925 AND deathdate after 2015... etc > > - Evelyn > It wouldn’t matter whether you have Legacy 7.5, 8 or 9; this > procedure works for all Legacy versions. > Your Uncle is going to 90, therefore, he was born in 1927 > Using Search > Find > Look for Whom: Individual > Where to Look: Birth Date > How to Look: Before > What to Look For: 1927 > Second Condition : AND > Look for Whom: Individual > Where to Look: Birth Date > How to Look: After > What to Look For: 1926 > This will find anyone in your database who is born for the > whole year of 1926, because whole year dates are taken from 1 > Jan to 31 Dec. > > In my database, the above returned 8 individuals. > > If I changed the first What condition to 17 Aug 1927, and > left the second What condition as is, I will increase this to > 19, as it will include everyone between 1 Jan 1926 AND 17 Aug > 1927. > Easy. > > > Kind Regards,Mark > > *From:*LegacyUserGroup > [mailto:legacyusergroup-boun...@legacyusers.com > <mailto:legacyusergroup-boun...@legacyusers.com>] *On Behalf > Of *Patricia Kruger > *Sent:* Thursday, 17 August 2017 6:44 AM > *To:* legacyusergroup@legacyusers.com > <mailto:legacyusergroup@legacyusers.com> > *Subject:* [LegacyUG] How to query in 7.5 > > I am using Legacy 7.5. I want to find out who in my database > has lived longer than my 'soon-to-be 90 year old- uncle. So > how do I query the data to identify individuals who have lived > 90 years or more. Thanks. > > > Evelyn .. <mailto:ej1...@gmail.com> > Thursday, 17 August 2017 8:11 AM > That only looks at birth year. If someone were born in 1926 and died > in 1927 they would still show up on that list, but they aren't over 90 > yrs old. > > If you look at birth year before 1927 AND death year is blank then > you'd get all the people who are still alive and 90+. It would also > pick up all those people who don't have a death date entered yet > because it isn't known. It would miss those born before 1927 and lived > 90+ years before dying. > > The person has to be born in 1926 or earlier and either still be alive > (no death date) or they died after they turned 90 (death year minus > birth year). > > Since age is a calculated amount and I don't know how to do that in > Legacy, you might have to do a separate search for: > 1) those who were born before 1927 and are still alive (death date blank) > 2) then for each year before 1927 > birthdate before 1926 AND deathdate after 2016 > birthdate before 1925 AND deathdate after 2015... etc > > - Evelyn > > > > > -- > Evelyn Wilhelmson > ej1...@gmail.com <mailto:ej1...@gmail.com> > 509-998-6743 > Mark <mailto:markl...@adam.com.au> > Thursday, 17 August 2017 7:28 AM > > Patricia, > > It wouldn’t matter whether you have Legacy 7.5, 8 or 9; this procedure > works for all Legacy versions. > > Your Uncle is going to 90, therefore, he was born in 1927 > > Using Search > Find > > Look for Whom: Individual > > Where to Look: Birth Date > > How to Look: Before > > What to Look For: 1927 > > Second Condition : AND > > Look for Whom: Individual > > Where to Look: Birth Date > > How to Look: After > > What to Look For: 1926 > > This will find anyone in your database who is born for the whole year > of 1926, because whole year dates are taken from 1 Jan to 31 Dec. > > In my database, the above returned 8 individuals. > > If I changed the first What condition to 17 Aug 1927, and left the > second What condition as is, I will increase this to 19, as it will > include everyone between 1 Jan 1926 AND 17 Aug 1927. > > Easy. > > Kind Regards, > > Mark > > *From:*LegacyUserGroup > [mailto:legacyusergroup-boun...@legacyusers.com] *On Behalf Of > *Patricia Kruger > *Sent:* Thursday, 17 August 2017 6:44 AM > *To:* legacyusergroup@legacyusers.com > *Subject:* [LegacyUG] How to query in 7.5 > > I am using Legacy 7.5. I want to find out who in my database has > lived longer than my 'soon-to-be 90 year old- uncle. So how do I > query the data to identify individuals who have lived 90 years or > more. Thanks. > -- LegacyUserGroup mailing list LegacyUserGroup@legacyusers.com To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/legacyusergroup@legacyusers.com/
-- LegacyUserGroup mailing list LegacyUserGroup@legacyusers.com To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/legacyusergroup@legacyusers.com/