On Fri, 6 Jan 2006 14:03:23 +1100, "Jennifer Crockett" <[EMAIL PROTECTED]> wrote:
>I have Access 2002, but am not familiar with Access at all. If someone >would be willing to tell me, step by step, how to find and remove the >blank lines, I would appreciate it. If there is another way of doing the >same thing, I am very open to suggestions. I think the update query to remove an initial blank line from event notes would be... UPDATE tblER SET [Desc]=Mid([Desc],3) WHERE Asc([Desc])=13; This assumes there are NO spaces in that initial blank line ... just a CRLF pair. Maybe Brian can confirm this. As always, make a backup of your database first. The usual disclaimers apply. -- Dennis M. Kowallek [EMAIL PROTECTED] ****************** Legacy User Group guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
