Jenny, Dennis Thank you for clearing that up, I got there in the end. Even breaking the query down with advanced tagging will end up with the same results. Alan
-----Original Message----- From: Dennis M. Kowallek [mailto:[email protected]] Sent: 09 November 2011 13:16 To: [email protected] Subject: Re: [LegacyUG] doing an event search On Wed, 9 Nov 2011 12:24:50 -0000, "Alan Pereira" <[email protected]> wrote: >That suggests the "AND" operators are not working properly. No, it is working properly ... just not the way you expect. In English, Jenny's query looks something like... Find all individuals with an event where EventName equals "England Census" AND with an event where EventDate equals "02 April 1911" AND with an event where EventDescription contains "Clerk". If an individual had 3 events as follows... 1) EventName "England Census" EventDate "02 April 1891" EventDescription "Smith" 2) EventName "Residence" EventDate "02 April 1911" EventDescription "123 Mayfair" 3) EventName "Occupation" EventDate "02 April 1901" EventDescription "Clerk" ... the individual would be selected. What she really wanted was... Find all individuals with an event where EventName equals "England Census" AND EventDate equals "02 April 1911" AND EventDescription contains "Clerk". -- Dennis Kowallek (LTools/Custom Programming) http://zippersoftware.com/ltools/index.htm http://groups.yahoo.com/group/ltools NOTE TO LUG USERS: Use plain text if you want me to read your post. 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
