Addition in a Form

  • Thread starter Thread starter DoveArrow
  • Start date Start date
D

DoveArrow

I'm trying to add the numbers from two different text boxes together
in a third text box. Pretty straightforward, right? Well, instead of
getting the sum of the two numbers, Access is putting the number from
the first text box next to the number from the second text box like
so:

13 + 2 = 132

The funny thing is that if I subtract the numbers, the formula works
just fine.

13 - 2 = 11

Can someone please explain what's going on? Thanks.
 
Make sure both fields are number fields. If so then =[field1]-[field2]
should work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top