URGENT: Errors running report

N

Nick M.

I'm getting an error "Exceeded System Resource" when running a mission-critical report in the dbase I'm working on. I've rebooted, run the database repair tool (on a copy); no results. I've tried deleting sections of the report; there is an area, between one of my headers and a footer, 3" to 6", which, when deleted, allows my report to run. On the way to discovering this piece of real estate, I've gotten myriad errors, including "Query is too complex." I've tried narrowing down the culprit further, to no avail.

HELP!

Does anyone know what's up with this thing? I've got other reports, all fed from the same query, that work. For that matter, the query itself works. I need to get this report up-and-running. I loathe the idea of having to re-write it ... but, if this doesn't work, I will have to ... Please save me from a 20 hour work day!!

Nick M.
 
Top