Limit on Number of Fields

[AccessHelp]

Hello all,

I just tried to run a select query, and I got an Overflow error message.

My select query has about 55 fields, and I don't know that is the problem.
Does anyone know the limit on number of fields a select query can have?

Also can someone help me with this overflow message?

Thanks.

 

[John W. Vinson]

Hello all,

I just tried to run a select query, and I got an Overflow error message.

My select query has about 55 fields, and I don't know that is the problem.
Does anyone know the limit on number of fields a select query can have?

Also can someone help me with this overflow message?

Thanks.

Overflow does not refer to too many fields; instead, it refers to a
calculation returning a number larger than can be handled by the datatype of
the field. For example, Integer fields can be no bigger than 32767.

You can sometimes get this error when you're dividing a large number by a very
small one for example.

Perhaps you could post the SQL view of the query that's causing the error, and
indicate what datatypes you're using.

 

[AccessHelp]

Hi John,

Thanks for the information.

My query is to extract data from the table that contains 50 states worth of
data. When I ran it for one state, I didn't get the overflow error message.
When I ran it for all 50 states, I got the overflow error message.

What I don't understand is if the issue is due to large number in a field,
wouldn't it matter weather I run it for one state or 50 states?

Please help. Thanks.

 

[John W. Vinson]

What I don't understand is if the issue is due to large number in a field,
wouldn't it matter weather I run it for one state or 50 states?

If you're summing or otherwise doing calculations with the data, I can easily
imagine that it would matter. However, I cannot see your database or your
query from here so I'm not in the best position to comment.