Question Why Isnt Access Adding Up Correctly?

[mitch_johnson]

hello i have a small problem please can anybody help:

i have tried to make an expression to add two numeric fields up in a form but instead of adding up like 1 + 0 = 1 it adds up 1+0 =10 anybody know how to fix this thanks

 

[Banana]

Probably because you're adding strings together somehow.

Are you doing this: "1" + "0" or otherwise performing a string function upon the numeric fields?

 

[mitch_johnson]

yeah i just put fieldname + Fieldname

 

[Banana]

What is the data type of each field?

 

[mitch_johnson]

numeric long inteager

 

[Banana]

Both of them?

Try and copy and paste the expression you were having problem with then.

 

[DCrake]

To be more forceful you could try

Answer = Val(Field1) +Val(Field2)