LeftTrim and RightTrim

[Guest]

I nee d remove 2 first characters in the field. What function should i use in
a query?
For example: '1 group', I will need to have just a word 'group'.

 

[Douglas J. Steele]

If it's always the first 2 characters you're trying to remove, use
Mid(MyTextField, 3)

 

[Rick B]

NewFieldName: Mid([CurrentFieldName],3)