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

Divide by zero error 2

Status
Not open for further replies.
shrubble

shrubble

MIS
Jul 23, 2003
300
US
Does anyone know of a quick and dirty way (preferably right in the report designer) to replace #ERROR with a 0 in a report field when a divide-by-zero error occurs?

Thanks!

"I would rather have a free bottle in front of me, than a pre-frontal lobotomy..."

-Shrubble
 
Sort by date Sort by votes
I use IIf() ie:
=IIf([SomeField]=0,0,[OtherField]/[SomeField])

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Search by Date and Some Text
Replies
9
Views
281
dhookom
dhookom
soloracer
  • Locked
  • Question
Problem using report recordsource values within report events. Error 2427 1
Replies
17
Views
390
soloracer
soloracer
monkeysee
  • Locked
  • Question
Group a calculated field by month in Access Report 2
Replies
5
Views
191
monkeysee
monkeysee
JoPaBC
  • Locked
  • Question
Rounding error
Replies
4
Views
167
JoPaBC
JoPaBC
Triacona
  • Locked
  • Question
run-time error 2585 - action can't be carried out - while using DoCmd.SendObject acSendReport 1
Replies
17
Views
425
Triacona
Triacona

Part and Inventory Search

Sponsor

Back
Top