If no data, I want zeros instead of #ERROR# 1

[dawnd3]

I have access 2000 and I want the report to show all the number fields as zero instead of ERROR if there is no data to report. Can this be done?

Thanks,

Dawn

http://www.calliopeconsulting.net

 

[PaulBricker]

Dawn, in the underlying table, if the field is Number, you can set the Default value to 0. That should take care of the problem. Post back if it doesn't and we'll look at the Nz function.

Paul

 

[dawnd3]

Thank you but that is only going to work if there are records with no amount entered. But this is a report with a bunch of calculated fields and their is no underlying data in the query for a particular customer, so all the calculations come up ERROR. But, no data means that the customer balance is zero (no records means no outstanding invoices) so I want the report to show zeros.

Make Sense?

Dawn

http://www.calliopeconsulting.net

 

[dhookom]

You need to use expressions like:
=IIf(HasData,Sum(NumField),0)
If this doesn't help, reply with some of the control sources of your text boxes.


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[dawnd3]

where do I use that Duane? In the OnNoData event? For each field that I want to show zero?

Thanks,

Dawn

P.S. here is just one of the text boxes...

=([OTotal]-Nz([OPayment]))

http://www.calliopeconsulting.net

 

[dhookom]

Use this in the control source:
=IIf(HasData, [OTotal]-Nz([OPayment],0),0)
I find it good practice to always have 2 arguments in every Nz() function.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.