Brian, Don't you mean death date after 1839? The problem is that this will give you those who were not born before 1839. If you tag those who have an Event place for Munzesheim then this will include those who lived there in any year, so even if you then search this list for those born before 1839 and died after that year you will hardly dent the original list, because it will include those who lived there either before or after 1839, but not in 1839.
The problem resolves to the fact that you wish to search a specific event, or more than one event eg. residence and census, with a specific date which applies only to that Event. Even more problematical if there is no specific Event, would be to look for someone who was there for a prior Event, and still there at a subsequent one. I'm sorry that I am only defining the problems, rather than giving a solution, and it just may be possible to work something out using only Legacy rather than SQL, but if so I have yet to see it. Ron Ferguson http://www.fergys.co.uk/ GOONS #5307 "Brian Lehman" <[email protected]> wrote: >Thanks Ron, >I'm trying to find all individuals in my data base, alive in Munzesheim >in say 1839. >Since I create an Event to record Birth, death and marriages, and I have >those dates for everybody in Munzesheim, >I am searching for individuals for, "Event Place"contains - Munzesheim, >that list I search for, "Death Date" before - 1840. >I don't think I'm searching correctly. >I cant be the first to attempt to search for individuals in a given >place in a given year, >wondering how others do their search. >Brian > > > > > > > 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
