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
------------------------------------------------------------------------
*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.
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.