The first thing to keep in mind is, how did you enter the information in the first place. For each burial in the DB, did you include in the location name, a naming system that puts the name of the cemetery and/or cremetoriam: Example: Jones Crematorium of Chicago, Cook County, Illinois, United States. or Pleasant Repose Cemetery of Chicago, Cook County, Illinois, United States. I don't. If you put the name in the Source title instead of/in addition to the location place name, it may be easier to breakdown. Some cemeteries/burying fields also provide cremation as part of the overall services available and may not have the word, 'crematorium' in the business name at all. You might want to revise your location naming system, or your source naming system to reflect this situation. But the computer, in general will only find matches of words, and not find various similar concepts spelled with different letters. I went through my DB in the past, putting in the Source details the word 'burial' or 'cremation', and/or 'lost at sea', 'body never found', 'cannibalism', and other descriptions of unusual disposal methods. Then you can search on those words to come up with a list for all using a certain method. We make it complicated, then expect the computer to understand how to 'guess' which things should be clumped together. We have to start out thinking how we will sort stuff later, then build into the system how to differentiate as we create. (I didn't either) Rich in LA CA
--- On Sat, 6/5/10, Sherry/Support <[email protected]> wrote: > From: Sherry/Support <[email protected]> > Subject: RE: [LegacyUG] Searching for persons that were cremated > To: [email protected] > Date: Saturday, June 5, 2010, 7:05 AM > Thanks Dennis, > > I don't see an option in the Detailed Search tab for > this. I'll pass it on to the programmers. > > Other listers might have a way to work around this, in the > meantime. > > Thanks for using Legacy. > > Sherry > Customer Support > Millennia Corporation > [email protected] > http://www.LegacyFamilyTree.com > > We are changing the world of genealogy! > > -----Original Message----- > From: Dennis M. Kowallek [mailto:[email protected]] > Sent: Saturday, June 05, 2010 6:17 AM > To: [email protected] > Subject: Re: [LegacyUG] Searching for persons that were > cremated > > On Sat, 5 Jun 2010 08:53:32 -0400, Lloyd <[email protected]> > wrote: > > > I would like to search for all > persons that were cremated, but cannot find the right > search to do it. > >Can someone show me the way to go? > > Not sure you can do it in Legacy. But you can do it easily > in SQL... > > SELECT tblIR.IDIR, tblIR.Surname, tblIR.GivenName > FROM tblIR > WHERE tblIR.Cremated=1 > > This will work in MS Access, OOBase, LTools, MDBPlus, etc. > > You should also send it to Millennia as a suggestion (if I > am not > overlooking the obvious). > > http://www.legacyfamilytree.com/suggest.asp > > -- > > Dennis Kowallek (LTools) > http://zippersoftware.com/ltools > http://groups.yahoo.com/group/ltools > > > > > > 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 > > 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 To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
