Calculation

[mike via AccessMonster.com]

Hi,

I had a form that calculates 2 fields (on reality it has actualy a positive
and negative values) i just change the format that will only show all the
positive value. Now i need to sum it up (in different textbox) for all the
positive and negative values.

Any help pls...thanks

 

[Allen]

Set the third field's control source to something like:

=txtOne + txtTwo

Include the equal sign.

The demo at http://www.aislebyaisle.com/access/tools2.htm has a wizard
that creates can create forms with a calculated field like this.