Calculations in form object

  • Thread starter Thread starter FredVN
  • Start date Start date
F

FredVN

Hi-

I'm a newbie to M/S Access. I need to do several calculations in a form
object. Basically I want to calculate 4 intermediate results, display them
individually, and then combine them into an additional result. I can do the
calculations in text boxes, but can not find a way to use those results in a
later calculation.



I realize I could repeat all 4 of the calculations in the later calculation,
but that seems error-prone and unnecessarily complex. The must be an easier
way. Would someone please explain how to do it. Thank you.



FredVN
 
I realize I could repeat all 4 of the calculations in the later
calculation, but that seems error-prone and unnecessarily complex. The
must be an easier way. Would someone please explain how to do it. Thank
you.
Click to expand...

Nope. You DO have to repeat the calculations in the later calculation. You
can't use a calculated field in a calculation. That's one thing that's teed
me
off about Access since 1.0.

Tom Lake
 
FredVN said:
I'm a newbie to M/S Access. I need to do several calculations in a form
object. Basically I want to calculate 4 intermediate results, display them
individually, and then combine them into an additional result. I can do the
calculations in text boxes, but can not find a way to use those results in a
later calculation.

I realize I could repeat all 4 of the calculations in the later calculation,
but that seems error-prone and unnecessarily complex. The must be an easier
way. Would someone please explain how to do it. Thank you.
Click to expand...


If the combined calculation text box is in the same section
(detail?) as the individual calculation text boxes, then you
can refer to the indivdual calculated values by using the
name of the text box.

If you want a group footer or report footer text box to
calculate the sum of the calculated values in all of the
details, then you must repeat the expressions inside the Sum
(or other aggregate function).
 
Back
Top