View original (French)

Convert text to numeric Access

Solved
ExcellenceConception -  
yg_be Posted messages 23437 Registration date   Status Contributeur 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 réponse

Réponse 1 / 1
yg_be Posted messages 23437 Registration date   Status Contributeur Last intervention   Ambassadeur 1 587
 
Hello,
it depends on the context, which you haven't provided.
Maybe by using the 
eval()
function?
0
ExcellenceConception
 
Thank you very much, you really inspired me.
Best regards.
0
yg_be Posted messages 23437 Registration date   Status Contributeur Last intervention   1 587 > ExcellenceConception
 
If necessary, could you mark the discussion as resolved?
0
ExcellenceConception > yg_be Posted messages 23437 Registration date   Status Contributeur Last intervention  
 
Yes, it's resolved.
0
ExcellenceConception > ExcellenceConception
 
Another question please:
- how to solve decimals?
Example: Eval("3+0.5+...")=#Error.

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