Cannot Open Any More Tables?

Y

yque

I'm putting together a report that is pretty much a sheet of totals based on
2 base tables. The report is broken down by Subdivision and Phase, and has a
total of 22 rows (each row is a subreport). Each row(subreport) has 33
columns of totals, ex: Total Lots, Model Homes, Un-Available Lots... Each of
the totals is derived from it's own query. After inserting 17 subreports
into the main report, it's showing me an error when I try to print that says
'Cannot Open Any More Tables'. I am able to preview the report, but all
subreports after the 17th print blank. Is this just too much for Access to
handle? Is there any way to simplify my database by running macros or code
to calculate the totals into a table rather than running queries for each?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Return Totals for multiple categories from a subreport 4
DB Documentation Report Crashes 0
Report and subreport w/Criteria Parameters issues 2
Report with pivot tables and pivot charts in sub reports 7
Sum Subreport Row Data 1
Cannot open any more tables 1
Subreport Madness 7

Top