Thanks Mark - but I'm not looking for anyone still alive. I want to be able to tell him (at his upcoming birthday gathering) that he is one of X number of our family who lived to at least 90 years (he may be the only one for all I know). Since there isn't a way to calculate and insert age (maybe an event creation?) , there is no way to sort and print a list that I can figure out. Any other ideas will be appreciated. Pat
From: Mark <markl...@adam.com.au> To: 'Legacy User Group' <legacyusergroup@legacyusers.com> Sent: Wednesday, August 16, 2017 7:30 PM Subject: Re: [LegacyUG] How to query in 7.5 #yiv0461376180 #yiv0461376180 -- _filtered #yiv0461376180 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv0461376180 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv0461376180 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv0461376180 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv0461376180 #yiv0461376180 p.yiv0461376180MsoNormal, #yiv0461376180 li.yiv0461376180MsoNormal, #yiv0461376180 div.yiv0461376180MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv0461376180 a:link, #yiv0461376180 span.yiv0461376180MsoHyperlink {color:blue;text-decoration:underline;}#yiv0461376180 a:visited, #yiv0461376180 span.yiv0461376180MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv0461376180 span.yiv0461376180EmailStyle17 {color:#1F497D;}#yiv0461376180 .yiv0461376180MsoChpDefault {font-size:10.0pt;} _filtered #yiv0461376180 {margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv0461376180 div.yiv0461376180Section1 {}#yiv0461376180 Patricia, It wouldn’t matter whether you have Legacy 7.5, 8 or 9; thisprocedure 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 wholeyear 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 leftthe second What condition as is, I will increase this to 19, as it will includeeveryone between 1 Jan 1926 AND 17 Aug 1927. Easy. Kind Regards, Mark From: LegacyUserGroup[mailto:legacyusergroup-boun...@legacyusers.com] On Behalf Of PatriciaKruger 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 90year old- uncle. So how do I query the data to identify individuals whohave 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/