The number of columns can be increased up to 255, but I don't believe the
default can be changed.
You can select multiple columns at one time and then use the insert Columns
menu item to add that number of columns.
== Click on the narrow gray bar at the top of the column and while holding
down the mouse button drag left or right to select multiple columns
== Select Insert Columns from the menu
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Have you tried sub-query?
Let's say you create a query of 23 columns, name it "A".
Create another query, "B" which has query "A" and add the rest of the
columns not added to the query yet.
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.
