One way to tackle this issue if you have a manageably-sized database (mine
has a little over 5,000 individuals total), is to put estimated birth dates
in for them all.
It took a while, but I did a search for all individuals where the birth and
death dates were blank. Then I used spouse's birth date and/or parent's
marriage dates to help me make a more sophisticated guess at their birth
date.
This is where I got into the problem with the search results screen not
letting me save edits (hint, hint - I STILL need to hear back from Support
on this problem I reported more than a week ago!)
It's one possible solution, but I realize that it may not be desirable to
some for several reasons. However, for me, I'm now able to better ensure
that I don't have any people over 200 years old still "living!"
Just a thought...
Gail Rich Nestor
Smyrna, Georgia, USA
www.roots2buds.net
----- Original Message -----
From: "Coddgenealogy" <[EMAIL PROTECTED]>
To: <LegacyUserGroup@mail.millenniacorp.com>
Sent: Sunday, January 22, 2006 12:59 PM
Subject: RE: [LegacyUG] Finding "dead" Livings with Access
Thanks!
I knew about that, and it does get a lot of them, but it didn't get a
woman who married a man born in 1857, nor the no-dates sister of man
born in 1784 and married to a no-dates husband. Besides, one might want
to use a sliding scale, e.g. 16th century no-dates don't live to 100,
but 20th century do.
One can use Microsoft Access to do sophisticated things in Legacy,
such as the above. A beginning on the query is: SELECT tblIR.Living,
tblIR.Surname, tblIR.GivenName, tblMR.HusbBirthSD, tblMR.WifeGivenName,
tblMR.WifeSurname, tblMR.WifeBirthSD, tblIR.DeathSD FROM tblMR INNER
JOIN tblIR ON tblMR.IDIRWife = tblIR.IDIR WHERE (((tblIR.Living)=0));
but this does only spouses, and lacks a less-than test date for either
husband or wife birthdates, e.g. 1900.
Jonathan
Legacy User Group guidelines can be found at:
http://www.LegacyFamilyTree.com/Etiquette.asp
To find past messages, please go to our searchable archives at:
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/
To unsubscribe please visit:
http://www.legacyfamilytree.com/LegacyLists.asp
Legacy User Group guidelines can be found at:
http://www.LegacyFamilyTree.com/Etiquette.asp
To find past messages, please go to our searchable archives at:
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/
To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
