G Guest Jan 5, 2005 #1 I need to trim the two charactesr from a field. I you have a simple sql command that would be great too.
I need to trim the two charactesr from a field. I you have a simple sql command that would be great too.
G Guest Jan 5, 2005 #2 Hi, Carlton. In an Update query, change the value of [YourField] to: =Right([YourField],len([YourField])-2) Sprinks
Hi, Carlton. In an Update query, change the value of [YourField] to: =Right([YourField],len([YourField])-2) Sprinks
F fredg Jan 5, 2005 #3 I need to trim the two charactesr from a field. I you have a simple sql command that would be great too. Click to expand... NewField = Mid([OldField],2)
I need to trim the two charactesr from a field. I you have a simple sql command that would be great too. Click to expand... NewField = Mid([OldField],2)
G Guest Jan 6, 2005 #4 Fred, You're right; Mid is a more efficient call. But shouldn't it be Mid([OldField],3) to trim the first two? Sprinks fredg said: I need to trim the two charactesr from a field. I you have a simple sql command that would be great too. Click to expand... NewField = Mid([OldField],2) Click to expand...
Fred, You're right; Mid is a more efficient call. But shouldn't it be Mid([OldField],3) to trim the first two? Sprinks fredg said: I need to trim the two charactesr from a field. I you have a simple sql command that would be great too. Click to expand... NewField = Mid([OldField],2) Click to expand...
