showing zeros when no amount

  • Thread starter Thread starter mon
  • Start date Start date
M

mon

Hi All helpers,
In my report I am trying to get either zero in the sum
total. I've tried NulltoZero, but I think it is really
empty. On some of the other reports I would like the
label and field not to show at all if there is no amount.
Thanks
Mon
 
You say you have tried NulltoZero. Have you tried Nz()?

Sum(Nz([Amount],0))

You would need an event trigger for hiding the control. When
you figure out which one is the best one on your form you
can use...

If Me![YourControlName] < .01 Then
Me![YourControlName].Visible = False
Else
Me![YourControlName].Visible = True
End If

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top