Dennis - Disregard my earlier request for clarification on removing
all the burial notes - I was able to apply the formula through the
LTools feature on a test of one of my saved files. It works really
great, but your 'SQL...' caution is not to be taken lightly! :-) is a
veritable axiom - the change occurred in a blink of an eye. I did
discover that the file had to be 'saved' out of Access or it rendered
the database useless (error). I had to delete it and re-save a valid
file to that location. I'm still trying to learn the LTools and its
features - it is pretty powerful. Thanks for the formula - I'll have
to study some of the others now that I see how they work.
Bob
On Sep 6, 2009, at 8:06 PM, Dennis M. Kowallek wrote:
On Sun, 06 Sep 2009 20:36:08 -0400, Lester Davis <les...@davisdeyoe.com
>
wrote:
and better yet is there a way to remove ALL of the burial notes?
I don't know of a way to do it in Legacy. But you can easily do it
using
MS Access or another tool.
UPDATE tblIR SET tblIR.BuriedNote = ""
--
Dennis Kowallek (LTools)
http://zippersoftware.com/ltools
http://groups.yahoo.com/group/ltools
Legacy User Group guidelines:
http://www.LegacyFamilyTree.com/Etiquette.asp
Archived messages:
http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/
Online technical support: http://www.LegacyFamilyTree.com/Help.asp
To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Legacy User Group guidelines:
http://www.LegacyFamilyTree.com/Etiquette.asp
Archived messages:
http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/
Online technical support: http://www.LegacyFamilyTree.com/Help.asp
To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp