View original (French)

Convert text to numeric Access

Solved
ExcellenceConception -  
yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   -
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 Posted messages 23437 Registration date   Status Contributor Last intervention   Ambassador 1 588
     
    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
      1. yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   1 588 > ExcellenceConception
         
        If necessary, could you mark the discussion as resolved?
        0
      2. ExcellenceConception > yg_be Posted messages 23437 Registration date   Status Contributor Last intervention  
         
        Yes, it's resolved.
        0
      3. ExcellenceConception > ExcellenceConception
         
        Another question please:
        - how to solve decimals?
        Example: Eval("3+0.5+...")=#Error.

        Thank you very much.
        0
      4. yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   1 588 > ExcellenceConception
          
        Eval("3+0.5+...")
        0