too many fields

J

Jeanne

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

JJ
 
J

Jeff Boyce

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
 
J

John W. Vinson

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

Access error 3059 0
ASK Field Formatting 1
You don't currently have permission to access this folder 0
"Fields Nested Too Deeply" Error in Simple Word Document 5
Fields are nested too deeply 2
Microsoft word: fields are nested too deeply 1
Too Many Fields Defined Error 1
Loop through pages and insert header image 0

Top