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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Zero Percent Doesn't Show on Report

Status
Not open for further replies.
Garridon

Garridon

Programmer
Mar 2, 2000
718
US
I have a report where I calculate the percentage of items that are overdue versus the total number of items. However, when there isn't anything overdue, Access leaves the space blank. Is there a way for it to list the 0%?
Linda Adams
Visit my web site for writing and Microsoft Word tips:
 
Sort by date Sort by votes
IN the text box you could use an iif statement. someting like iif(your statement, your result, '0%'). I do things similar to this in manye rports and haven;t really had any problems. Hope this helps
 
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
457
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Show Previous Year 1
Replies
5
Views
385
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
686
caykamanj1966
caykamanj1966
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
449
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
498
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top