none
Exporting a Report from Access RRS feed

  • 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

    Friday, May 6, 2016 9:33 AM

Answers

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

    • Marked as answer by Deon SA Tuesday, May 10, 2016 6:06 AM
    Tuesday, May 10, 2016 1:30 AM
    Moderator

All replies

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

    Miriam Bizup Access MVP

    Friday, May 6, 2016 9:52 AM
  • 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.

    Monday, May 9, 2016 7:03 AM
    Moderator
  • 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

    Monday, May 9, 2016 10:54 AM
  • 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.

    • Marked as answer by Deon SA Tuesday, May 10, 2016 6:06 AM
    Tuesday, May 10, 2016 1:30 AM
    Moderator
  • Thanks - The Nz function took care of both errors.

    Much appreciated.

    Tuesday, May 10, 2016 6:06 AM