On Tue, 13 Dec 2011 13:31:00 -0500, Jerry <jerrysemailgro...@gmail.com> wrote:
>Is there an option in Legacy (or perhaps LTools) to remove all the >instances where there is a source listed under UNSPECIFIED? Don't think Legacy has this feature, but in LTools "Run Raw SQL", or MS Access, run the following DELETE query... DELETE * FROM tblSX WHERE tblSX.Type=0 MAKE A BACKUP FIRST !!! tblSX.Type=0 refers to the "Unspecified" citation. See http://zippersoftware.com/wp/ltools/legacys-database/tblsx-type/ for more info. -- 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