subject:"Re\: \[LegacyUG\] How to query in 7.5"

Re: [LegacyUG] How to query in 7.5

2017-08-18 Thread CE WOOD

I am so glad you were able to help her. As for me, I never set my relationships 
to 999, which as you say, would be ridiculous (and yes I have gotten back to 
medieval and earlier times). What I am most interested in is direct 
ascent/descent, although I find it interesting to discover the ancestral 
relatives.



CE


From: LegacyUserGroup <legacyusergroup-boun...@legacyusers.com> on behalf of 
Cathy Pinner <genea...@gmail.com>
Sent: Thursday, August 17, 2017 8:51 PM
To: Legacy User Group
Subject: Re: [LegacyUG] How to query in 7.5

CE

Well I thought she wanted relatives. But if not, you just do it for the
whole Name List.
Still works.

Anyway have had a private email from Patricia thanking me and that she
found what she wanted.

Re the Relationship settings to 999 - unless you've got very complex
multiple lines of descent from multiple people - as in the royal
genealogies/medieval genealogies, as I think you do, it's a waste of
time to set it so high.
Set relationships doesn't give you non-blood relationships beyond
immediate in-laws. The Relationship Calculator does.

Cathy

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

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

>  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

Re: [LegacyUG] How to query in 7.5

2017-08-17 Thread Cathy Pinner


CE

Well I thought she wanted relatives. But if not, you just do it for the 
whole Name List.

Still works.

Anyway have had a private email from Patricia thanking me and that she 
found what she wanted.


Re the Relationship settings to 999 - unless you've got very complex 
multiple lines of descent from multiple people - as in the royal 
genealogies/medieval genealogies, as I think you do, it's a waste of 
time to set it so high.
Set relationships doesn't give you non-blood relationships beyond 
immediate in-laws. The Relationship Calculator does.


Cathy


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("",[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:

Re: [LegacyUG] How to query in 7.5

2017-08-17 Thread CE WOOD

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:

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) & amp; "/" & 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("",[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.

   sp; 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
bi rthdate 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
  & nbsp; 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 fi

Re: [LegacyUG] How to query in 7.5

2017-08-16 Thread Cathy Pinner


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:


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("",[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/

Re: [LegacyUG] How to query in 7.5

2017-08-16 Thread Linda Yocum

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("",[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/

Re: [LegacyUG] How to query in 7.5

2017-08-16 Thread Margaret Turner

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("",[BirthDate],[DeathDate]) AS
Age INTO tblAges FROM tempAges;



On 17 August 2017 at 10:11, Evelyn ..  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  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/

Re: [LegacyUG] How to query in 7.5

2017-08-16 Thread CE WOOD

Just because someone doesn't have a death date does not mean he is still alive. 
Many people do not have a death date because it is unknown, but they are 
obviously dead because they were born about 1325, or 1725, etc.


That's why Legacy 7.5 has the option:

  If there is no death date when saving a record: Ask if living if over 
 ; Set as dead if over .


For the many hundreds of people whom I have whose birth and death dates are 
unknown, I must use evidence of dated documents signed by or mentioning him to 
estimate a birth year.



CE



From: LegacyUserGroup <legacyusergroup-boun...@legacyusers.com> on behalf of 
Evelyn .. <ej1...@gmail.com>
Sent: Wednesday, August 16, 2017 5:11 PM
To: Legacy User Group
Subject: Re: [LegacyUG] How to query in 7.5

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<mailto: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/




--
Evelyn Wilhelmson
ej1...@gmail.com<mailto:ej1...@gmail.com>
509-998-6743
-- 

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/

Re: [LegacyUG] How to query in 7.5

2017-08-16 Thread Evelyn ..

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

-- 
Evelyn Wilhelmson
ej1...@gmail.com
509-998-6743
-- 

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/

Re: [LegacyUG] How to query in 7.5

2017-08-16 Thread Patricia Kruger

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/

Re: [LegacyUG] How to query in 7.5

2017-08-16 Thread Mark

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/

Re: [LegacyUG] How to query in 7.5

2017-08-16 Thread Maia Brasington

Sorry can't help

On 16 August 2017 at 22:14, Patricia Kruger  wrote:

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

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/

Re: [LegacyUG] How to query in 7.5

Re: [LegacyUG] How to query in 7.5

Re: [LegacyUG] How to query in 7.5

Re: [LegacyUG] How to query in 7.5

Re: [LegacyUG] How to query in 7.5

Re: [LegacyUG] How to query in 7.5

Re: [LegacyUG] How to query in 7.5

Re: [LegacyUG] How to query in 7.5

Re: [LegacyUG] How to query in 7.5

Re: [LegacyUG] How to query in 7.5

Re: [LegacyUG] How to query in 7.5

11 matches

Site Navigation

Mail list logo

Footer information