A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I increase the size of my Query



 
 
Thread Tools Display Modes
  #1  
Old May 18th, 2010, 01:03 PM posted to microsoft.public.access.queries
Gary
external usenet poster
 
Posts: 790
Default How do I increase the size of my Query

The default number of columns on my Access database is 24.
Can this be expanded to 40?
Thanks
  #2  
Old May 18th, 2010, 01:56 PM posted to microsoft.public.access.queries
John Spencer
external usenet poster
 
Posts: 7,815
Default How do I increase the size of my Query

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

Gary wrote:
The default number of columns on my Access database is 24.
Can this be expanded to 40?
Thanks

  #3  
Old May 18th, 2010, 03:20 PM posted to microsoft.public.access.queries
ron11311
external usenet poster
 
Posts: 1
Default How do I increase the size of my Query

On May 18, 8:03*am, Gary wrote:
The default number of columns on my Access database is 24.
Can this be expanded to 40?
Thanks


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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.