removing first letter of record in a field

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
 
C

coxml32 via AccessMonster.com

Here is what I would do.

Mid$([combo],2,19)

Hope this works.

bird said:
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...
 
F

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
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing/replace special character in a field 3
separating data before and after a hyphen. 3
update field in first record of query 8
Setting field value if a value exists in another table 0
Strip field data of quotation marks 3
use different equations in same query field 2
Setting field value if a value exists in another table 0
FIRST record in a match 2

Top