A
Allan May
I have a form that calculates a field as a % total.
Basically, each line has a quantity and I need to know
what % of the total that quantity is. I am using
[quantity]/sum[quantity]*100.
However, when I modify the quantity, the % doesn't change
to the correct % until I move to the next record. Is
there a way to make it do the sum calculation without
requiring the move to the next record?
Thanks.
Basically, each line has a quantity and I need to know
what % of the total that quantity is. I am using
[quantity]/sum[quantity]*100.
However, when I modify the quantity, the % doesn't change
to the correct % until I move to the next record. Is
there a way to make it do the sum calculation without
requiring the move to the next record?
Thanks.