On Thu, 18 Aug 2011 01:32:16 -0400, Jerry <[email protected]> wrote:
>What I'm doing is transferring or moving the >one source name, which is the book called Merriam Genealogy in England >and America, from the NAME field into the UNSPECIFIED field instead. UPDATE tblSR INNER JOIN tblSX ON tblSR.IDSR = tblSX.IDSR SET tblSX.Type = 0 WHERE ((tblSX.Type=1) AND (tblSR.SrcTitle="Merriam Genealogy in England and America")) Try it on a copy of your database and see if it does what you want. You may have to tweak the SrcTitle if that's not exactly what you named it. In English, it says... Change the source detail to point to UNSPECIFIED (Type = 0) on any record that is pointing at NAME (Type = 1) AND has a master source title of "Merriam Genealogy in England and America". So, in effect, it MOVES the detail from NAME to UNSPECIFIED if the title is... You get the gist. If there are records with that title pointing at NAME that you don't wish to move, more conditions will have to be added to the WHERE clause. Fairly safe query as long as you try it on a copy of your database first and verify that it does what you want. MS Access will tell you how many rows it is about to update, so if that doesn't look correct you can abort. But really no need to if you are trying it on a copy. -- Dennis Kowallek (LTools) 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
