Too many fields defined???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some very lengthy and complex queries I am running that has about 45 columns in it, and once I'm done with the subqueries, I am using a UNION ALL statement to join them together. The problem I am running into is that while each of the three main subqueries will run individually, the whole query gives me the message Too many fields define. I can't find anything in the help. Is there some parameter/property I can set to get this to work as a union.

TIA

Mark
 
Mark

If the error message is to be believed, you have too much to hold in one
query statement. Does your UNION query work if you include fewer columns?
 

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

Union Query - Too Many Fields 3
too many fields defined 2
Query is too complex after install Access 2007 SP 2 !? 25
Reference Calculated Field 2
Triple Key Match with nulls 2
Query is too complex 5
query too complex when transposing 2
Too many tables 1

Back
Top