|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 13th, 2006, 08:36 PM
posted to microsoft.public.access.queries
|
|||
|
|||
split text in access 2000
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. 
|
|
#2
October 13th, 2006, 10:06 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
split text in access 2000
Stupid and can prove it. wrote: 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. Okay, you proved it. Left$([FieldName],Len$([FieldName])-1)
|
|
#3
October 13th, 2006, 10:47 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
split text in access 2000
Told you I could
Hey! This works great. I won't ask this stupid question again Thanks " wrote: Stupid and can prove it. wrote: 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. Okay, you proved it. Left$([FieldName],Len$([FieldName])-1)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
