LeftTrim and RightTrim

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

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'.
 
If it's always the first 2 characters you're trying to remove, use
Mid(MyTextField, 3)
 
Back
Top