how to create an addition formula

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I am new to access and would like to creat a value from 2 created boxes
Does anyone know how I would create the formula so that if "Box 1 has a
value of 2 imputed and "Box 2" has a value of 3 imputed it would total five
in area where I need the amount totaled from box 1 and 2. Hope this makes
sense. thanks for anyone that can help.
 
I am new to access and would like to creat a value from 2 created boxes
Does anyone know how I would create the formula so that if "Box 1 has a
value of 2 imputed and "Box 2" has a value of 3 imputed it would total five
in area where I need the amount totaled from box 1 and 2. Hope this makes
sense. thanks for anyone that can help.
Click to expand...

If this is on a Form, you could simply set the Control Source property of Box3
to

=[Box1] + [Box2]

If you're trying to do this in a Table... *don't*. Tables are not
spreadsheets, do not contain formulas, and shouldn't be seen by users in any
case; they're for storing data. Calculations should be done in Queries or on
Forms or Reports.
 
=(Nz([box1],0)+Nz([box2],0))

--
Wayne
Manchester, England.



John W. Vinson said:
I am new to access and would like to creat a value from 2 created boxes
Does anyone know how I would create the formula so that if "Box 1 has a
value of 2 imputed and "Box 2" has a value of 3 imputed it would total five
in area where I need the amount totaled from box 1 and 2. Hope this makes
sense. thanks for anyone that can help.
Click to expand...

If this is on a Form, you could simply set the Control Source property of Box3
to

=[Box1] + [Box2]

If you're trying to do this in a Table... *don't*. Tables are not
spreadsheets, do not contain formulas, and shouldn't be seen by users in any
case; they're for storing data. Calculations should be done in Queries or on
Forms or Reports.
Click to expand...
 
Back
Top