Text Box is Zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that shows weekly deductions from employees checks. One
particular deduction is either = $0.00 or > than $0.00. If the text box
(named txtDeduct) that shows the deduction is equal to $0.00 then I want it
to be blank. So if run 10 week report I want the txtDeduct to show when it
has the deduction greater than $0.00. There are other deductions on the
report so I can not change the underlying query. Any help is appreciated.
 
Have you looked into using the Nz() function? Have you considered using an
IIF() function in the query, something like:

IIF(Nz([YourField],0)=0,"",[YourField])

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top