IIf Error Expression in Query

[DoneganF]

Hello All - I have an expression in a query in which I need to layer in an "If Error" clause. I tried the following, but received the error message;

"The expression you entered has a function containing the wrong number of arguments"

Here's the expression I entered:

NETCOLL:=IIf(IsError([PAYMENTS]/([CHARGES]-[CONTRACTUALS]),0,[PAYMENTS]/([CHARGES]-[CONTRACTUALS]))

Any insight is greatly appreciated!

 

[Gasman]

I *think* you are way off base.? Do you use Excel mostly?

This user tried much the same thing.?

https://stackoverflow.com/questions/22670418/iif-iserror-function-still-returning-error

 

[DoneganF]

I was actually looking for some suggestions on how to resolve the expression. But thank you for the advice on tagging future posts - I will definitely utilize tags going forward.

Again .... any help on resolving the expression is greatly appreciated!

 

[Gasman]

In English, what are you trying to identify that would produce a zero value?

 

[DoneganF]

When I run the base expression, without trying to trap errors, certain records (where Charges = 0) will return the following error; #Num!

Here is the base expression
[PAYMENTS]/([CHARGES]-[CONTRACTUALS])

What I want the error expression to do is replace the #Num! with a 0.

 

[Gasman]

Would this logic satisfy your requirements?

https://www.techonthenet.com/access/queries/divide_by_zero.php

 

[plog]

certain records (where Charges = 0) will return the following error; #Num!

Mostly incorrect. Records where Charges=Contractuals will return #Num!

Use that in conjunction with Gasman's advice