Query - Too many fields defined

  • Thread starter Thread starter Shawn
  • Start date Start date
Probably because you have too many fields defined. Can you tell us anything
about the tables involved in your query and your SQL view?
 
Is the query by any chance a CROSS-TAB Query?

If so, then the crosstab is creating more than 255 columns (in Access 97 and
Access 2000).

If this is not the problem, can you post the text of your SQL query.
 

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

too many fields defined 2
Total Number of fields in a query 4
export crosstab query too many fields defined 4
Union Query - Too Many Fields 3
Fields in a query 4
Too Many Fields Defined Error 1
Query with too many fields 7
Too many Fields Define ? 2

Back
Top