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" <[EMAIL PROTECTED]> 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]
