too many fields

[Joe]

I get a "too many fields" error in a query. Documentation
indicates that you can have up to 250 fields. My query
only has 151. Why do I get this error?

Thanks,

Joe

 

[John Vinson]

I get a "too many fields" error in a query. Documentation
indicates that you can have up to 250 fields. My query
only has 151. Why do I get this error?

Whenever you add or change a field definition, Access "uses up" one of
the 255 slots. Compact your database to recover the missing ones. If
this doesn't help, perhaps you could describe the query (I hesitate to
ask you to post the SQL!)

151 fields is an INCREDIBLY wide recordset, except for some crosstabs!
Do your Tables have an inordinate number of fields?

 

[John Spencer (MVP)]

Actually you can have up to 255 fields (columns) in a query. However, that
includes any fields in a subquery, or a nested query - EVEN if you don't display
them in the query.

 

[Joe]

-----Original Message-----
I get a "too many fields" error in a query. Documentation
indicates that you can have up to 250 fields. My query
only has 151. Why do I get this error?

Thanks,

Joe
.

I did do a compact and repair, still no luck.

I am doing calculations on a series of products for a
series of processes so it adds up.

Thanks for the help

 

[John Vinson]

I am doing calculations on a series of products for a
series of processes so it adds up.

Do you perchance have fields for each product, or for each process,
rather than records? Maybe your table design is at the root of the
difficulty.