removing first letter of record in a field

[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

 

[fredg]

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

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.