Remove Characters

  • Thread starter Thread starter Tony Ramirez
  • Start date Start date
T

Tony Ramirez

I have a field that reads CS-080000-A and I want it to read CS-080000 so I
always only want the first nine characters of the field. How would I write
this in an access query.

Thanks!!!

Tony
 
I have a field that reads CS-080000-A and I want it to read CS-080000 so I
always only want the first nine characters of the field. How would I write
this in an access query.

Thanks!!!

Tony
Click to expand...

NewColumn:Left(FieldName],9)
 
Back
Top