Calculations in a form

[Guest]

I have a form made up with fields from a table to input figures- I then added
calculations into my form to "add up those figures" which work fine in the
form itself but when I go back to the table - it does not include any
figures in the fields which have a calculation(in the form) - What am I doing
wrong?
-- Thankyou in anticipation
SCP

 

[Rick Brandt]

I have a form made up with fields from a table to input figures- I
then added calculations into my form to "add up those figures" which
work fine in the form itself but when I go back to the table - it
does not include any figures in the fields which have a
calculation(in the form) - What am I doing wrong?
-- Thankyou in anticipation
SCP

Controls either contain an expression OR save values to the table. They
cannot do both.

The good news is you shouldn't be saving calculated values anyway. You have
a perfectly valid expression that gives the value you want. Just use that
expression wherever you need that value.

 

[Joseph Meehan]

I have a form made up with fields from a table to input figures- I
then added calculations into my form to "add up those figures" which
work fine in the form itself but when I go back to the table - it
does not include any figures in the fields which have a
calculation(in the form) - What am I doing wrong?

You are trying to save a calculated result. You don't really want to do
that (well almost never) Access is happier just dong the calculation every
time you want to see the result than to save the result and display that
when you want. It will also automatically update if you update any of the
source numbers.

Just use the same formula anytime you want to display the result.