DSum

  • Thread starter Thread starter Alimbilo
  • Start date Start date
A

Alimbilo

How can I have the DSum to only calculate de Sum when a field is updated?
Because it keeps on adding the same value over and over when I open the form.
If the field value is 50, verytime I do a DSum for that field, it's always
add 50 even though I only have 1 row.
 
Difficult to say without a better explanation of what you want to achieve but
are you using the correct criteria?

DSum(expr, domain, [criteria])
 
How can I have the DSum to only calculate de Sum when a field is updated?
Because it keeps on adding the same value over and over when I open the form.
If the field value is 50, verytime I do a DSum for that field, it's always
add 50 even though I only have 1 row.
Click to expand...

Correct the error in your DSum() function call.

Since we can't see it and do not know what it is that you want to sum, it's
more than a bit difficult to help!

Please post the actual dsum expression, and indicate how you're calling it,
and what you intend for it to do. Remember: YOU can see your computer. YOU
know what you're trying to do. We cannot and do not.
 
Back
Top