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> 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> 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] *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/