Cathy, Your solution is the best way to currently find what I need. Like you, I can usually find anything I need within Legacy, or LTools. Thanks for reminding me the export, sometimes the simplest answers are overlooked.
It does bring to mind however, that it surprises me there is no "centralized" listing of SQL queries that the thousand of Legacy users have created and used on their own over the years, I do remember somehow MANY years ago, I had calculated that less than 2/10 of 1 % of persons in my rather large database lived past 100, so that is why I have always set 100 as "dead if older than" age. Thanks, Jay On Sun, May 25, 2014 at 2:58 AM, Cathy Pinner <[email protected]> wrote: > Hi Jay, > > Did you see my solution? I haven't seen a comment on it. > > Far easier than all the data entry that Mike is suggesting, though, when > found you may want to enter an event for those who did live to be 100. And > none of that helps you find what you want NOW. > > Of course if you can manipulate an Access database, all sorts of things > are possible but I've never bothered to learn as I can do most things I > want from within Legacy. > > The Name List Report can include Age of Death. Creating the csv and > opening it in a Spreadsheet is a simple thing to do. > The way to find living over 100 is a bit round about but it should work by > narrowing the group you need to consider. > > Cathy > > > Mike Fry wrote: > > On 25 May 2014 10:50, Jay 1FamilyTree wrote: > > > >> I have over 200,000 people in my file, please do not suggest I enter > the age > >> of death for every one..... > > > > Are they all dead? Do you have start and end dates for them? If not then > your > > task is greatly reduced. > > > > > > 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
