If no data in rpt field print 0

A

andy

In a report we have a calculated field (numeric). I would
like to print a zero if there is no value (isnull?). Would
someone please tell me how to do this? And where do I put
the code snippet, in the control source attribute of the
property of the field? Or do I use the expression builder?
and if so again on what attribute of the property of the
field?

Thank you in advance
God bless you
 
V

Van T. Dinh

Use the Nz() function. You can use it in either the Query
being used as the RecordSource for the Report or in the
ControlSource for the Control (i.e. TextBox) on the Report.

Check Access VB Help on the Nz() function.

HTH
Van T. Dinh
MVP (Access)
 

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

Whats wrong with this: =IIf([OrdPmtAmt]>0,"Paid","UnPaid") ?? 10
Print 0 in field if no data 1
Using expression builder to format a report field 4
Want Sum in Report Header of calculated field in Report Detail ? 1
Printed report different to preview 0
Refresh field 0
Calculating averages on a form 3
Rpt totals of datediff field only if checkbox of another field che 1

Top