Calculations on a Form

[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.

 

[Debra Farnham]

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]

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

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.

.

 

[Mike Painter]

Do the calculations also work on fields that are set as
currency?

<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.