Error: "Too Many Fields Defined" in Query

[Greg]

I'm trying to run a very large query, and I get an
error: "Too Many Fields Defined." I have 87 fields, but
need 92 for a mail merge document that runs off this
query. The "help" option offers a blank screen.

Is there any way to expand the number of fields allowed
in a query. (Note: I tried reducing the number of sorts
performed by the query, and that expanded the field
allocation a little, but not enough).

Thank you.

 

[Greg]

John, Thanks for the explanation and idea. I didn't
know subqueries counted against the total. I converted
the output of one of the subqueries (80 fields) into a
table and inserted it in the main query in place of the
sub. If I converted 80 fields from the subquery,
shouldn't I have 80 new fields free in the main query?
It doesn't seem to be working that way.

Thanks. Greg

 

[John Vinson]

John, Thanks for the explanation and idea. I didn't
know subqueries counted against the total. I converted
the output of one of the subqueries (80 fields) into a
table and inserted it in the main query in place of the
sub. If I converted 80 fields from the subquery,
shouldn't I have 80 new fields free in the main query?
It doesn't seem to be working that way.

I don't think so - you're trading 80 fields in the Query for 80
fields in the Table. Without spending a lot more time digging through
your complex query than I can spare at the moment, I don't know what
else to suggest!

 

[Greg]

John,

The temporary table worked great as a short term
solution, and I now understand how the software counts
against the field limit. Thanks for your help!

Greg