Limit of tables/queries in reports

  • Thread starter Thread starter Isaiah
  • Start date Start date
I

Isaiah

I was wondering if there is a limit to the number of
tables and queries I can get fields from in a report.

I have about 36 queries that I am getting fields from.
When I add one of two fields from each query to the report
(using the Wizard) I get a message saying that it could
not run the report. I don't get any kind of error message
saying what I the problem is.

I can make smaller reports using the same queries and it
works.
 
Isaiah

While I am not sure what the exact enswer to your question is, I would suggest that perhaps you might want to build a query that gets all these fields from all these queries, and then create a report based on that query. And if it turns out that you can't make a query from 36 different sources and maintain any kind of relationship among them, perhaps you might want to work you way toward a final report, kind of like making 4 queries based on 9 inputs each, and then making a query using the results of those 4, and then basing the report on that query

Bob Sulliva

----- Isaiah wrote: ----

I was wondering if there is a limit to the number of
tables and queries I can get fields from in a report

I have about 36 queries that I am getting fields from.
When I add one of two fields from each query to the report
(using the Wizard) I get a message saying that it could
not run the report. I don't get any kind of error message
saying what I the problem is

I can make smaller reports using the same queries and it
works.
 
I was wondering if there is a limit to the number of
tables and queries I can get fields from in a report.
Click to expand...

Of course. Access cannot handle infinity; no computer can said:
I have about 36 queries that I am getting fields from.
When I add one of two fields from each query to the report
(using the Wizard) I get a message saying that it could
not run the report. I don't get any kind of error message
saying what I the problem is.
Click to expand...

This is a VERY VERY strange way of building a report, if I may say so!
Normally one would create one or a small number (for Subreports) of
queries specifically for the report. How are you "adding one or two
fields from each query", given that a Report can have only a single
Recordsource property? What are these Queries?
 
The reason I have so many queries is that some of the
queries don't always return something. I did try to
create one query for this report, but if ONE of the
queries didnt return anything then NOTHING was returned.
So I found that if I built a report and used small queries
that, if one of them didn't come back with anything, the
other still would.

This works when I use about 15 or so individual queries
but not too much more then that. That's why I was
wondering if there was a limit to the number of queries
you could use in a report.

I am sure there is a much better way to do this but I
don't know what it is.
 
Back
Top