Formula Error in Access Database

Question

HI,

I have wrritten formula some of the records are showing #Num! error. Can some help me. Below example for your reference.

Name	Salary	Loss of Pay	Salary-Incentive	% of salary Paid
Raghu	12000	7000	5000	41%
Tanvir	0 (Value is Zero in this record)	0 (Value is zero in this record)	0(Value is zero in this record)	#Num! (This is the Error)

In excel we have IFERROR function that will help to convert error to 0% but access i am not able to do this.

Can some one please help me.

Thanks,

K Raghavender Rao

Answer 1

You can use this expression - remembering that all expressions inside IIf(..) are always validated:

=IIf([Salary]=0,0,[Salary Incentive]/IIf([Salary]=0,1,[Salary]))

Answer 2

Use IIf.

=IIf([Salary]=0,0,[Salary Incentive]/[Salary])

Answer 3

.............remembering that all expressions inside IIf(..) are always validated

Actually, that's not the case in a query or in a calculated control in a table, one of which I imagine is the case here; in which case the second IIF function call is unnecessary.  Only the TRUE result is evaluated in those contexts.

Answer 4

If you are having a problem with an expression or piece of code, please post the expression or code you are using

Answer 5

We can't correct what we cannot see.  What is the expression you've used to compute the percentage?