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?
