removing first letter of record in a field

  • Thread starter Thread starter bird lover
  • Start date Start date
B

bird lover

Working in access 2003. Have many record with field information in field
[combo] such as N081118-2008-001850. I want to strip off the first character
so that it reads 081118-2008-001850. Syntax would be greatly appreciated for
an update query. I don't know programming languages
 
Working in access 2003. Have many record with field information in field
[combo] such as N081118-2008-001850. I want to strip off the first character
so that it reads 081118-2008-001850. Syntax would be greatly appreciated for
an update query. I don't know programming languages
Click to expand...

Every record?
Back up your table first.
Here is the SQL for an update query.

Update MyTable Set MyTable.FieldName] = Mid([[FieldName],2)

Change MyTable to whatever the actual table name is.
Change [FieldName] to whatever the actual name of the field is.
 
Back
Top