Can somebody help me with something that I thought should be simple in the first place:
I have a continous form with a footer with a control "D", that sums the field debito, wich is a numeric field
=Sum([debito])
Instead of the sum of the numeric fields, the returned result is blank. I noticed that instead of summing if I just set the D control to [debito], it returns the first result in the form correctly.
I tried the following with no results :
=Sum(nz[debito]))
=Sum(cdbl([debito]))
also tried in the current event of the form :
Any thoughts on what I am doing wrong ?
I have a continous form with a footer with a control "D", that sums the field debito, wich is a numeric field
=Sum([debito])
Instead of the sum of the numeric fields, the returned result is blank. I noticed that instead of summing if I just set the D control to [debito], it returns the first result in the form correctly.
I tried the following with no results :
=Sum(nz[debito]))
=Sum(cdbl([debito]))
also tried in the current event of the form :
Code:
If Me.RecordsetClone.RecordCount = 0 Then
Me.D.ControlSource = ""
Me.D = 0
Else
Me.D.ControlSource = "=Sum([debito])"
End If
Any thoughts on what I am doing wrong ?