too many fields

  • Thread starter Thread starter Joe
  • Start date Start date
J

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
 
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?
Click to expand...

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?
 
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.
 
-----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
.
Click to expand...

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
 
I am doing calculations on a series of products for a
series of processes so it adds up.
Click to expand...

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.
 
Back
Top