Hello~
I use SUM() to calculate value in subform on main Access Form by control data source (Below is "Test" file).
But the value would become unchangeable. So I want to calculate value by using VBA code.
I have tried to use DSum fn, but I failed. Maybe I used the wrong code.
Can any one tell me how to write the code?
Also, can SUM fn skip Null and properly calculate value?
I use SUM() to calculate value in subform on main Access Form by control data source (Below is "Test" file).
But the value would become unchangeable. So I want to calculate value by using VBA code.
I have tried to use DSum fn, but I failed. Maybe I used the wrong code.
Can any one tell me how to write the code?
Also, can SUM fn skip Null and properly calculate value?