Add 2 text fields error 2

[Tekhelpnet]

I need sum of 2 fields from the table. Text datatype.
I am writing =[Field1]+[Field2]
and it gives me
2 3 23 instead of 5
1 5 15 instead of 6

What is wrong with my formulas?

=VAL[Field1]+VAL[Field2] gives error
SUM([Field1],[Field2]) gives error as well...

Thanks

 

[Remou]

You are missing brackets:

=VAL([Field1])+VAL([Field2])

 

[dinger2121]

try this -

CDbl([Field1])+CDbl([Field2])