Adding Values in A form

[sgfromny]

I'd Like to take three fields and add them together as follows:
[field1] + [Field2] - [field3]

Seems simple enough, but the result I get is a combination of the fields. eg. "field1field2"

The values are numbers???? What the?

help please.

 

[Rick39]

Try Sum([field1] + [Field2]) - [field3]

 

[sgfromny]

Nope, I get a ?name error in the field

 

[Ason1976]

Have you thought about basing your form on a query instead of a table? I find it works better when using calculations doing it that way.