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/

Reply via email to