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 ________________________________ From: LegacyUserGroup <legacyusergroup-boun...@legacyusers.com> on behalf of Margaret Turner <mgroga...@gmail.com> Sent: Wednesday, August 16, 2017 8:25:56 PM To: Legacy User Group Subject: Re: [LegacyUG] How to query in 7.5 If you are willing to plunge into the world of SQL !!! I am of no help in SQL :( here is a working example from Ltools (now free) which works only in Legacy 7 (hence my dependence on 7.5) http://zippersoftware.com/wp/ https://groups.yahoo.com/neo/groups/ltools/conversations/topics/1022 ==== Finding persons died under age 15 SELECT IDIR, BirthD, DeathD, DateValue(Mid([BirthD],5,2) & "/" & Mid([BirthD],3,2) & "/" & Mid([BirthD],7,4)) AS BirthDate, DateValue(Mid([DeathD],5,2) & "/" & Mid([DeathD],3,2) & "/" & Mid([DeathD],7,4)) AS DeathDate INTO tempAges FROM tblIR WHERE ((IDIR<>0) AND (BirthD Like "00*") AND (DeathD Like "00*") AND ((Mid([BirthD],3,2))<>"00") AND ((Mid([BirthD],5,2))<>"00") AND ((Mid([DeathD],3,2))<>"00") AND ((Mid([DeathD],5,2))<>"00")); I do this just to make the next query easier to read. SELECT IDIR, BirthD, DeathD, DateDiff("yyyy",[BirthDate],[DeathDate]) AS Age INTO tblAges FROM tempAges; ==== On 17 August 2017 at 10:11, Evelyn .. <ej1...@gmail.com<mailto:ej1...@gmail.com>> wrote: 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 On Wed, Aug 16, 2017 at 4:28 PM, Mark <markl...@adam.com.au<mailto:markl...@adam.com.au>> wrote: 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<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.
-- 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/
