Dear Richard,

In Excel, there is an IFERROR function that one could use to trap Divide By Zero Errors. Is there an equivalent function in Access?
In one of my reports, i have to calculate percentages. However, if  there are no records in the parameters supplied to the query, i get a Num# error in some textboxes in the report. So far, i am using an ad hoc solution. It first checks if the denominator will be a zero before the division can take place as shown below;
=IIf([TotalPatients]=0,0,[ChildrenOnly]/[TotalPatients])

Is there a better way that i could do this? I have heard of HasData property but i have failed to get it to work for a textbox.

Please advice me

MICAH

---

Reply from Richard Rost:

As far as I know there is no IFERROR function in Access or VBA. It's an Excel-only function.

There is an "On No Data" event for each report. It will fire if there are no records. You can then make your code gracefully abort the report load. Something like:

MsgBox ("There are no records to show.")
Cancel = 1

Aside from that, your solution is fine... or you could run a DLOOKUP before you launch the report (in the button code, perhaps) to check TotalPatients.