#Num! Error of Report Text Box

[Hayton]

Hi Guys,

=IIf(IsError([txtFR1]/[txtTot]),0,[txtFR1]/[txtTot])

For the formula above, when txtTot is 0, it shows the #Num! error.

I have tried using IsError function to get around it and it does not work.

Any suggestions would be appreciated.

Hayton McGregor

 

[PHV]

Why not simply this ?
=IIf([txtTot]=0,0,[txtFR1]/[txtTot])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Hayton]

Hi PHV,
Thanks for the reply.

Hayton McGregor