Exporting access report to excel-Error message

[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

 

[NTC]

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....

 

[Duane Hookom]

Change the control sources so they don't divide by zero:
=IIf({Your expression}=0, Null, {Another Expression}/{Your expression})