How do I increase the size of my Query

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

The default number of columns on my Access database is 24.
Can this be expanded to 40?
Thanks
 
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
 
The default number of columns on my Access database is 24.
Can this be expanded to 40?
Thanks
Click to expand...

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.
 
Back
Top