Text Box is Zero

L

Lamar

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.
 
J

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

merge fields at bottom of document causing two pages 1
Employee Paysheet 1
how to monitor stock quantity 3
Pie Chart in Access 0
update query 3
Creating a summary page without blank lines 1
Not printing zero... 1
[Black]$#,##0.00;[Red]($#,##0.00);[Blue]$0.00 (CUSTOM FORMAT) 3

Top