On Wed, 9 Nov 2011 16:44:52 -0000, "Alan Pereira" <alanpere...@tiscali.co.uk> wrote:
>Even breaking the query down with advanced tagging will end up with the same >results. You can do it with Access or LTools. Using Jenny's example, the query would look something like ... SELECT tblIR.IDIR AS RIN FROM (tblET INNER JOIN tblER ON tblET.IDET = tblER.IDET) INNER JOIN tblIR ON tblER.IDIR = tblIR.IDIR WHERE (((tblET.EventType)="England Census") AND ((tblER.IDType)=0) AND ((tblER.Description)="Clerk") AND ((tblER.EventD) Like "0002041860*")); This query has not been tested thoroughly. If you wanted to tag the individuals on Tag1... UPDATE (tblET INNER JOIN tblER ON tblET.IDET = tblER.IDET) INNER JOIN tblIR ON tblER.IDIR = tblIR.IDIR SET tblIR.Tag1 = 1 WHERE (((tblET.EventType)="England Census") AND ((tblER.IDType)=0) AND ((tblER.Description)="Clerk") AND ((tblER.EventD) Like "0002041860*")); Again, not tested thoroughly. -- 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/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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