errors in report

  • Thread starter Thread starter subs
  • Start date Start date
S

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
 
Trap error before it happens. Use IIF statement to display comment if
results would be error testing for zero or nulls.
 
Back
Top