HAHAHAHAHHAHAHAHHAHAHHAHA No I didn't notice!!
But, I've been banging my hean on this issue for so long that i guess I typed it in proper format without thinking!! HAHAHAHHAHAHA --- In [email protected], "L Tumbulu" <[EMAIL PROTECTED]> wrote: > > You are welcome. Sorry that there was an error in my suggestion which I think you noted and corrected. The bracketing was wrong. Instead of writing Right([SNField],7) I wrote Right([SNField,7]). > > Good day > > Liveson > > > ----- Original Message ----- > From: wigliff_the_viking > To: [email protected] > Sent: Thursday, 27 March, 2008 3:13 PM > Subject: [ms_access] Re: Update query and editing cell contents > > > Excellent. > > Works well. > > Thanks!!! > > --- In [email protected], "L Tumbulu" <l.tumbulu@> wrote: > > > > Try this SQL (Query) > > > > UPDATE YourTable SET SNField = Right([SNField,7]) WHERE > YourCriteria. > > > > It is advisable to make a backup first just in case things go wrong > and sometimes they DO. > > > > HTH > > > > Liveson > > > > ----- Original Message ----- > > From: wigliff_the_viking > > To: [email protected] > > Sent: Wednesday, 26 March, 2008 4:49 PM > > Subject: [ms_access] Update query and editing cell contents > > > > > > Hello Access Gurus > > > > I'm working with an inventory database and have a list of serial > > numbers. I need to remove the first character from the serial > numbers > > for specific models. I can sort the models out, but I can't seem > to > > phrase the "Update To:" command to shave the first character from > the > > SN. The existing SN is 8 characters long. I need to remove the > first > > character (an "S") to make the SN 7 characters long. > > How can I do this? > > > > > > [Non-text portions of this message have been removed] >
