Ask Your Question

maximum number of fields in query designer [closed]

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-13 19:53:38.243864

1 Answer

Sort by » oldest newest most voted

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

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 +0100 )edit

Question Tools

1 follower


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

Seen: 119 times

Last updated: Aug 27 '17