I have a report in Access which can be exported as PDF without a problem. When I try to export it to Excel I get an Overflow error. I have exported other reports multiple times and never faced an issue like this one
The explanation I got from Internet is as below
The "Overflow" error means that you are trying to put a number into a variable (or property etc), and the data type of the variable doesn't allow numbers that large.
The report converts to PDF without an error. Why is there no error in this case?
The report is based on a query which exports to Excel without an issue. I want to create a report for grouping etc but the overflow error is faced even before creating any groups etc!