number of columns in a query

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

Hi,
my query is full, but I need more columns. Is there a maximum numbers
of columns you can have? On a similar note, say I was to "cut" columns
from the design of my query, how would I then "insert" more columns?

Thanks
Kate
 
I'm pretty sure that 255 is the maximum number of columns. I'm also pretty
sure that you don't need to use even 1/4 that many if your database is
designed correctly.

You can add columns to the limit by dragging them from the table fields or
double-click on the table fields.
 
Fabulous, thanks.

P.S.
No I didn't have 255 columns, I only had about 15 and needed 2 more!
 
Fabulous, thanks.

P.S.
No I didn't have 255 columns, I only had about 15 and needed 2 more!
Click to expand...

It may just be a problem with the query grid interface, not with the
query itself. Select a couple of columns and choose Insert... Columns
to add a couple more, or go to SQL view (View... SQL) and edit the
fieldnames into the SELECT clause.
 
Back
Top