split text in access 2000

  • Thread starter Stupid and can prove it.
  • Start date
S

Stupid and can prove it.

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

pietlinden

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)
 
S

Stupid and can prove it.

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