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
