View original (French)

Convert text to numeric Access

Solved
ExcellenceConception -  
Hello,

How can we convert this expression ("2+5+7") which is in text format, to get the result (the sum) in numeric format?

Thank you in advance.

1 answer

  1.  yg_be Contributor
    Hello,
    it depends on the context, which you haven't provided.
    Maybe by using the 
    eval()
    function?
    0
    1. ExcellenceConception
      Thank you very much, you really inspired me.
      Best regards.
      0
    3. ExcellenceConception
      @yg_beYes, it's resolved.
      0
    4. ExcellenceConception
      @ExcellenceConceptionAnother question please:
      - how to solve decimals?
      Example: Eval("3+0.5+...")=#Error.

      Thank you very much.
      0