errors in report

[subs]

hi

in an access report there is a field called as cost/lb and it displays
as division/0 error or num! error whenever lb is 0 or lb is empty. i
want to eliminate these errors from my report. i.e these errors should
not be visible in the report. i still want cost/lb calculation for
other rows of data

is there a way where i can do this cost/lb calcuation only when lb is
not zero or not null. i am basically doing this calcuation in the
report itself


Thanks for help

 

[KARL DEWEY]

Trap error before it happens. Use IIF statement to display comment if
results would be error testing for zero or nulls.