Yes, I was using: > UPDATE tblER > SET [Desc]=Mid([Desc],3) > WHERE Asc([Desc])=13;
Maybe I missed part of the thread. Do you mean this? > Update tblER > SET [Desc] = Right([Desc], Len([Desc]-2)) WHERE Chr$(Left([Desc],1) = > CHR$(13)) Or was there something else? > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dennis > Kowallek > Sent: Sunday, January 08, 2006 2:24 PM > To: [email protected] > Subject: Re: [LegacyUG] Working with a Legacy File in MS Access 97 > > You said that Asc was causing the problem. The code I saw of Brian's did > not use Asc. > > Here is Brian's SQL... > > Update tblER > SET [Desc] = Right([Desc], Len([Desc]-2)) > WHERE Chr$(Left([Desc],1) = CHR$(13)) > > -- > > Dennis > > *** > > On Sun, 8 Jan 2006 14:15:30 -0800, "Dave Keeney" <[EMAIL PROTECTED]> > wrote: > > >That's where I get the "Invalid Procedure Call" error. > > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED] On Behalf Of > Dennis > >> Kowallek > >> Sent: Sunday, January 08, 2006 1:57 PM > >> To: [email protected] > >> Subject: Re: [LegacyUG] Working with a Legacy File in MS Access 97 > >> > >> On Sun, 8 Jan 2006 13:48:08 -0800, "Dave Keeney" <[EMAIL PROTECTED]> > >> wrote: > >> > >> >I have tried this in Access 2003 and can't seem to get it right. > >> > >> Try Brian's SQL. I have Access 2002. > >> > >> -- > >> > >> 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
