query field limit?

  • Thread starter Thread starter zxcv
  • Start date Start date
Z

zxcv

Hi,
I was creating a query in design view (access 07), and because it was a
bigger query than I normally do, and noticed that the number of columns
stopped at 16. Is the number of fields in a query really limited to 16? If
so, I find that very hard to believe. If not, why does it stop at 16 and how
do I add additional columns?
Thank you
 
255 fields is the max. You can get the limitations in the Help, under
"Access Specifications".


Hoping it may help,
Vanderghast, Access MVP
 
The query grid only shows 16 columns to start with.

You should be able to insert columns - in versions prior to Access 2007
that was Insert: Columns on the menu. In Access 2007, there is probably
a way, but I don't know it off the top of my head.

You can try just dragging the fields you want to include to the grid.
In versions prior to 2007, the necessary number of columns would
automatically be added to the display grid.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
The next time I tried a query, it did automatically add columns. I think it
must have been a bug (which will hopefully be fixed when sp1 is released!)
Thanks
 
Back
Top