data entry from claculation

  • Thread starter Thread starter BOB
  • Start date Start date
B

BOB

Can you have a data entry form that will update the totals in the table.
After you enter different numbers on the form.

form has enty 1 entry 2 entry 3
total = sum( entry1 +entry2+entry 3)


When each of the entries is changed on the from it updates the entry
channge on the table.
How, do I get the totals to change on the table?
I can't get the total from the form to update the table totals now that the
data has changed

How do you get the total in the table to change? so that after entries have
been make on the form the totals change on the table.

Is this possible to do easily?
 
BOB said:
Can you have a data entry form that will update the totals in the table.
After you enter different numbers on the form.

form has enty 1 entry 2 entry 3
total = sum( entry1 +entry2+entry 3)


When each of the entries is changed on the from it updates the entry
channge on the table.
How, do I get the totals to change on the table?
I can't get the total from the form to update the table totals now that the
data has changed

How do you get the total in the table to change? so that after entries have
been make on the form the totals change on the table.
Click to expand...

You don't, or at least you shouldn't. Calculated values should almost never be
stored as you are suggesting. Just calculate them when you need them. To
reduce the number of calculations you need to write, create a query based on
your table and add the calculation to the query. Then just use the query every
place you would ordinarily have used the table.
 
Back
Top