Ask Your Question

maximum number of fields in query designer

asked 2017-08-26 23:08:57 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have a table with about 30 fields. When I go into query designer, I am only able to put in about 20! Why is there this limit? Or am I doing something wrong? Is there a way to expand it? I went in to the SQL and was able to add another field there. It then shows up in Design View. Would prefer not to have to code in all of the other fields.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-08-27 00:24:13 +0200

Ratslinger gravatar image


Using design mode I quit adding fields after 31. When you have filled the last column, just double click on another field from your table selection & the column will be added.

If this answers your question please click on the ✔ (upper left area of answer).

edit flag offensive delete link more


It worked!!!! Not intuitive in the least and really clunky as you can only add one field at a time! Thanks.

WayneRhodes gravatar imageWayneRhodes ( 2017-08-27 01:18:12 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-26 23:08:57 +0200

Seen: 76 times

Last updated: Aug 27 '17