Kurt, did you try the SQL script that I provided? It works great. I found about 750 marriages in my database that fit the criteria. It gave me a good pool to check against Find a Grave. Quite a few of them are now proven to be deceased.
One hint that I forgot to mention. Ltools wants the entire script as one line (without CRLF between the lines). MS Access ignores the line spacing and other white space. On Thursday, June 5, 2014 2:07 PM, Kurt Kneeland <[email protected]> wrote: That’s a tough one. Even with Ltools of MS Access or some other way to do a direct SQL Query, I’m having difficulty envisioning the structure of that query. It would involve a complex join of the living selected from the individuals table with the marriage table to get the spouses and then back to the individuals table to get the spousal birth dates. Within Legacy, you can create a search list of ‘living” persons who have spouse (spouse surname not equal [blank]). You could then scroll through the search list, with the family tab showing, which will show spouses and their dates of birth, and manually tag the applicable records. It could be a tedious task if you have a lot of living individuals in your database. From:Jay 1FamilyTree [mailto:[email protected]] Sent: Tuesday, June 03, 2014 5:00 PM To: [email protected] Subject: [LegacyUG] Search for Hoping someone might be able to figure out how I can search for 'living' persons whose Spouse is born before 1920. I dont see any way to use dates against spouses in a selection parameter. Thanks in advance for any help Jay Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
