too many fields

  • Thread starter Thread starter Jeanne
  • Start date Start date
J

Jeanne

I am getting a "Too Many Fields" error pop up when running a query. Please
advise what this means.

JJ
 
Jeanne

Access will typically display this message if it believes you are requesting
more fields than it can display.

If you'll copy the SQL statement (open the query in design view, click on
the SQL view, copy) and paste it into another post here, the newsgroup folks
would have some more specific information on which to base our suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I am getting a "Too Many Fields" error pop up when running a query. Please
advise what this means.

JJ
Click to expand...

A single Query can have no more than 255 fields. Do you?
 

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 Error 1
Too many fields error message 2
export crosstab query too many fields error 1
Too Many Fields 1
Rounding Numbers 2
Too many IIF statements 3
How do I concatenates two fields into one field in the same table? 3
Too many fields 3

Back
Top