data on forms doesnot carry over to table

  • Thread starter Thread starter nikki Rawles
  • Start date Start date
N

nikki Rawles

Hello,
I have a field that contains a formula that calculates %
based on information that is entered on the form. All the
information carries over to the table EXCEPT for the %
(the field that contains the formula)... Any
suggestions.....Any help would be greatly appreciated!
 
nikki said:
Hello,
I have a field that contains a formula that calculates %
based on information that is entered on the form. All the
information carries over to the table EXCEPT for the %
(the field that contains the formula)... Any
suggestions.....Any help would be greatly appreciated!
Click to expand...

Don't bother storing that value, as you can always calculate it again
when you query the table. That also guarantees you will get a correct
outcome, in case you had changed a value inbetween.

Repeat: don't store the result of record calculations.
 
Back
Top