Exporting access report to excel-Error message

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

The make-table query that makes my report contains calculated fields... I
cannot export it due to error message: Division by zero. Is there any way to
get around this? I definitely need it exported, and the calculated fields.

Please help,
Jennifer
 
don't fully understand but in general terms where ever the math is
potentially a division by zero you need to control that....

maybe wrap that potential equation with an IIF statement that controls the
value....
 
Change the control sources so they don't divide by zero:
=IIf({Your expression}=0, Null, {Another Expression}/{Your expression})
 
Back
Top