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.
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).
It worked!!! Not intuitive in the least and really clunky as you can only add one field at a time! Thanks.