number of columns in a query

[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

 

[Arvin Meyer [MVP]]

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.

 

[Kate]

Fabulous, thanks.

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

 

[John W. Vinson/MVP]

Fabulous, thanks.

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

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.