Re: Reporting on a large polygon
I am running a report on all species in a city-sized (Newcastle) polygon and am receiving the following message in the Report Wizard:
"The size of the query used to generate your report is exceeding the maximum limit set by Access and as such can not be executed.
Please go back to the Places Selection page and amend your selection."
The number of records in the polygon could potentially be over 100,000. I assume this is why I am receiving this message; is there a limit as to how many records can be generated in a single report?
Thank you,
Francesca