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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Reports Eliminate #Error in Fields?
- Thread starter Cleis
- Start date
MichaelRed
Programmer
If they are all val/Val2 - where val2 = 0, then use a conditional:
=IIF([Val2], [val]/[val2], 0)
Of course, val and Val2 need to be replaced w/ YOUR filed names.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
=IIF([Val2], [val]/[val2], 0)
Of course, val and Val2 need to be replaced w/ YOUR filed names.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
- Status
Similar threads
- Locked
- Question
- Locked
- Question