D
dp
Hi guys,
I have a problem with my Grandtotal line which occurs intermittantly. I
have asked for help on this before on the past but, cant seem to resolve
this. On my report, I have a field set to running sum over all,
"commissionsrunningsum", it is bound to my query field, commissions, it is
the header section. Then I have in my report footer the grand total for this
=[commissionsrunningsum].
I can see the running sum field adding the values correctly and 95% of the
time the grand total is correct, however some times the grand total value is
the value of the first recordset only. ie
invoice 1, 7000
invoice 2, 1000
Grandtotal, 7000 (s/b 8000)
Has anyone heard of this problem?? Or have any ideas. I have already tried
using sum(), but it doesn't work properly because if there is more than 1
detail line it adds the value more than once.
Thanks in advanced,
David
I have a problem with my Grandtotal line which occurs intermittantly. I
have asked for help on this before on the past but, cant seem to resolve
this. On my report, I have a field set to running sum over all,
"commissionsrunningsum", it is bound to my query field, commissions, it is
the header section. Then I have in my report footer the grand total for this
=[commissionsrunningsum].
I can see the running sum field adding the values correctly and 95% of the
time the grand total is correct, however some times the grand total value is
the value of the first recordset only. ie
invoice 1, 7000
invoice 2, 1000
Grandtotal, 7000 (s/b 8000)
Has anyone heard of this problem?? Or have any ideas. I have already tried
using sum(), but it doesn't work properly because if there is more than 1
detail line it adds the value more than once.
Thanks in advanced,
David