showing zeros when no amount

[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

 

[Gary Miller]

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
________________________