Calculations on a Form

  • Thread starter Thread starter Julian
  • Start date Start date
J

Julian

I am sure this has been asked before,

I have a form that has several fields I would like to add
together and display interactively. I have seen that
calculations can be done and have tried to use the =sum
([fieldname]+[fieldname]) in the control source to no
avail.

Any help would be appreciated.
 
Hi Julian

try the following as the control source for the textbox on your form/report

=[fieldname]+[fieldname] assuming of course that both fields contain
numbers

HTH

Debra
 
Do the calculations also work on fields that are set as
currency?
-----Original Message-----
Hi Julian

try the following as the control source for the textbox on your form/report

=[fieldname]+[fieldname] assuming of course that both fields contain
numbers

HTH

Debra

Julian said:
I am sure this has been asked before,

I have a form that has several fields I would like to add
together and display interactively. I have seen that
calculations can be done and have tried to use the =sum
([fieldname]+[fieldname]) in the control source to no
avail.

Any help would be appreciated.
Click to expand...


.
Click to expand...
 
Julian said:
Do the calculations also work on fields that are set as
currency?
Click to expand...
<snip>
Yes.
However it would be better if you used a query that held the calculations.
That way you can treat them as ordinary fields and can base forms and
reports on the same information.
 
Back
Top