Exporting a Report from Access

Question

Hi all,

I want to export a report from MS Access 2013 to Excel. The report gets its data from a query based on a table. Exporting the report to Excel with the relevant data, works fine.

I have added some additional text boxes to the report where I do some calculations on the data in the report. When I export the report with the customised text box calculations, I get an error message "Overflow".

I then did the calculations in the query and added the fields to the report, but I get the same error message.

Can anybody help

Thanks

Deon

Answer 1

What are your calculations?  If using division, are you handling nulls/zeros to avoid overflows from division by zero?

---

Miriam Bizup Access MVP

Answer 2

Hi Deon SA,

I agree with mbizup MVP you did not mention your calculations.

I also have doubt that this error occurs due to Null values or Zero values.

will you please check that about Nulls and Zeros can solve your issue.

if it doesn't solve the problem please try to provide your calculations so that we can check it on our side and try to help you.

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 3

Hi,

Running the report in Access, I get the following errors on some lines in the calculated fields:

#Num!

#Type!

I assume this is due to division by zero, etc. How can I handle these errors in the report?

Thanks

Deon

Answer 4

Hi Deon SA,

you did not mention what calculations are so here we can only make an assumptions.

For #Num! Error please visit the link below.

Access Report Shows #Num! Error

#type (type mismatch) appears to be something other than a number. It may need to be converted to a number before you can work with it as a number

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 5

Thanks - The Nz function took care of both errors.

Much appreciated.