Cont Form and Row Total

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryan Hughes - 18 Jul 2005 19:28 GMT

Hello,

I have a continuous form that has 5 fields the user inputs numbers in the
first 4 fields, then the total of the fields for that record goes into the 5
field.

How do I get the total for those fields for a single row to auto update the
total field for that row after user updates a row?

-TFTH
Bryan

Reply to this Message

Marshall Barton - 18 Jul 2005 20:01 GMT

>I have a continuous form that has 5 fields the user inputs numbers in the
>first 4 fields, then the total of the fields for that record goes into the 5
>field.
>
>How do I get the total for those fields for a single row to auto update the
>total field for that row after user updates a row?

That would be a relational database normalization rules
violation. You should not save values that are calculated
from other values, especially from values in the same
record. Just perform the same calculation whenever you need
to display the total to users.

Signature

Marsh
MVP [MS Access]

Reply to this Message