Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

#Num! Error of Report Text Box

Status
Not open for further replies.
Hayton

Hayton

Technical User
Oct 17, 2001
257
NZ
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

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

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Hi PHV,
Thanks for the reply.

Hayton McGregor

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
106
caykamanj1966
caykamanj1966
monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
198
dhookom
dhookom
visitnag
  • Locked
  • Question
combo box entries problem
Replies
8
Views
183
visitnag
visitnag
TrekBiker
  • Locked
  • Question
Spurious Change of Fonts
Replies
3
Views
169
dhookom
dhookom
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
732
JanaLNelson
JanaLNelson

Part and Inventory Search

Sponsor

Back
Top