Addition issue in formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two fields that are the result of calculations.

value of col 1 = 137
value of col 2 = 135

total: [col1]+[col2]
result 137.135

when I change the + to -
result 2

why would it treat a + different than a - .... Is it a format issue...
 
stickandrock said:
I have two fields that are the result of calculations.

value of col 1 = 137
value of col 2 = 135

total: [col1]+[col2]
result 137.135

when I change the + to -
result 2

why would it treat a + different than a - .... Is it a format issue...
Click to expand...


Access thinks col1 and/or col2 are text fields so it's using
the + as the alternate concatenation operator.

Double check the field types in the table's design view.

If nothing else works, change the expression to explicitly
convert the field values to a number:

Total: Int([col1]) + Int([col2])
 
Back
Top