Overflow error

  • Thread starter Thread starter Pele
  • Start date Start date
P

Pele

I was trying to use a maketable query run through a macro
and a small window popped up that said overflow. Can
somebody tell me what could be causing this. The data
being use is less than 50,000 records.

Pele
 
I think that it is often caused by calculations that divide by 0. Is there
any chance of this in your query? If not, it may help if you can post the
sql of your query.

HTH, Ted Allen
 
Ted,

Thanks foryour insight. The other thing I notices is that
the overflow erro only happens when I group the records.
There are 4 fields (Customer ID1, Product Name, Customer
ID2, UnitSpend). The UnitSPend happens to have lots of
records with $0.

Let me know why the overflow occurs when I press the
grouping icon but not when the query is not grouping the
data.

Pele
 
Well, I could think of a few things that could be causing it. You don't say
what you are doing with the unitspend field in the query, but I assume that
you are probably totalling or averaging it. If you are totalling it, the
result may be exceeding the range of the data type. For instance, an integer
field can only hold up to 32,768.

On the other hand, if you are averaging, it could be that the 0's are
causing a problem and you may have to manually calc the average.

Post the sql text of your query (from sql view) and I can look further if
you like.

-Ted Allen
 
Ted,

You were very right with your original thoughts. On
further digging, the cause of the overflow error was that
the application was dividing by zero and it displayed
#error for some records. As soon as I try to group these
records, then the #error becomes an issue and I get the
overflow erro warning.

Everything has been fixed. Thanks.

Pele
 
My pleasure, glad it helped.

Ted Allen

Pele said:
Ted,

You were very right with your original thoughts. On
further digging, the cause of the overflow error was that
the application was dividing by zero and it displayed
#error for some records. As soon as I try to group these
records, then the #error becomes an issue and I get the
overflow erro warning.

Everything has been fixed. Thanks.

Pele
Click to expand...
 
Back
Top