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!

Receiving #Num! error while calc fields with 0 value.

Status
Not open for further replies.
ajhts

ajhts

Technical User
May 1, 2001
84
US
I am calculating a percentage in my report. Works great unless there are 0's in the fields. Whenever there are 0's it comes back with #Num! How do I tell it to produce a 0% figure if this happens??

Thank you!

AJ
 
Sort by date Sort by votes
I found the answer I was looking for, sorry to bother everyone with this thread! Have a great day!

AJ
 
Upvote 0 Downvote
Post one of your formulas...if you just choose "Percent" with the FORMAT property (just under Control Source property)you should not have any problems...

Control Source: =[Field1]/[Field2]
Format: Percent
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
230
dhookom
dhookom
RonMcIntire
  • Locked
  • Question
Page Numbering a report with vba
Replies
6
Views
186
dhookom
dhookom
PLCBeetle
  • Locked
  • Question
Pass Form value to Report Record Source
Replies
4
Views
118
dhookom
dhookom
Kennelbloke
  • Locked
  • Question
Problems with image on report 1
Replies
8
Views
142
dhookom
dhookom
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
218
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top