split text in access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Access 2000 database has a field [NUMBER] that contains variable quantity
of chars ending with an alpha "A". I want to remove the "A" at the end of
each one. There may be "A's" in other positions of the string that I do not
want to affect.
 
Stupid said:
My Access 2000 database has a field [NUMBER] that contains variable quantity
of chars ending with an alpha "A". I want to remove the "A" at the end of
each one. There may be "A's" in other positions of the string that I do not
want to affect.
Click to expand...

Okay, you proved it.
Left$([FieldName],Len$([FieldName])-1)
 
Told you I could

Hey! This works great. I won't ask this stupid question again

Thanks

[email protected] said:
My Access 2000 database has a field [NUMBER] that contains variable quantity
of chars ending with an alpha "A". I want to remove the "A" at the end of
each one. There may be "A's" in other positions of the string that I do not
want to affect.
Click to expand...

Okay, you proved it.
Left$([FieldName],Len$([FieldName])-1)
Click to expand...
 
Back
Top