Hello!
There are several records in a subForm, like below. At the footer of the subForm, I want to calculate PRICE according to conditions, the total price of condition "a" minus The total price of condition "b".
For example, the condition of No. 1, 2, 4 is "a", and the condition of No. 3 is "b". So, the result should be (100+150+120)-100=270.
No. PRICE Con.
1 100 a
2 150 a
3 100 b
4 120 a
How can I do this?
Thanks in advance!
There are several records in a subForm, like below. At the footer of the subForm, I want to calculate PRICE according to conditions, the total price of condition "a" minus The total price of condition "b".
For example, the condition of No. 1, 2, 4 is "a", and the condition of No. 3 is "b". So, the result should be (100+150+120)-100=270.
No. PRICE Con.
1 100 a
2 150 a
3 100 b
4 120 a
How can I do this?
Thanks in advance!