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})
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Report to Excel 2
exporting 9
Hiding a #Num! occurrence in a report output 4
Export Report to Excel 1
Access report export to Excel 1
Report exporting different data from what is on the report 1
Export report to excel ERROR - please help 3
Access 2007 Report Export To TXT Line Wrapping... 2

Back
Top