data on forms doesnot carry over to table

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!
 
B

Bas Cost Budde

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
How to have two tables on same line? 1
Crating User Form to Add Names 1
Adding data to MS Access from csv file 0
Copy previous record into form field 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
How do I clear a form? 0
Delete all data after a symbol in a field 0

Top