How to remove last character from a field in ACCESS

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sfleming
    New Member
    • May 2010
    • 4
    #1

    How to remove last character from a field in ACCESS

    I am trying to remove the last character from a field with variable length. I have tried the following several times and I continue to get an "Invalid Syntax" error.
    Code:
    Left([EName], Len[EName] -1)
    Please help.
    Last edited by NeoPa; May 6 '10, 04:43 PM. Reason: Please use the [CODE] tags provided.
    Tags: None
    • sfleming
      New Member
      • May 2010
      • 4
      #2
      Never mind. I just realized I had something missing. This fixed it.
      Code:
      Left([EName], Len([EName]) -1)
      Last edited by NeoPa; May 6 '10, 04:43 PM. Reason: Please use the [CODE] tags provided.

        Comment

        • missinglinq
          Recognized Expert Specialist
          • Nov 2006
          • 3533
          #3
          It's always nice when you can solve the problem yourself!

          Welcome to Bytes!

          Linq ;0)>

            Comment

            Previous template Next
            Working...