Query is size limited??

[sillykristi]

I have a total of around nine tables. I have a query that ties these nine tables together, pulling only certain information. However, it seems that when I run the query with more than around fifteen fields, it comes up with no information. Is there a limit to how much data you can pull in a query. I'm trying to feed this query to a report and having the same problem.

Help, Please!!

 

[Newman]

It happens to me last week. What I've done, (perhaps not the best way to do it, but it works) I created two queries, with one of them using half the tables, and the other one the other half + the other query.

 

[sillykristi]

OK, that might work! Can you help me with the report problem that lies within? I'm just trying to create a report based on all this data. If I use more than 2 queries or tables, nothing shows up. I need all this data on one report. Do I need to just go to the "Report" discussion page?

Thanks!

 

[Newman]

I'm not certain of where lies your problem...
If you use the method I wrote and bring the second query(the one with the other query in it) as the «Source» of the report it should work perfectly.
Else, I can't tell you what to do... Sorry!