Overflow Error

[justlearning2003]

Hi everyone,

I have a crosstab query created and when I run it I get an "Overflow" Error appear. Anyone have any ideas why this is happening?

Thanks

 

[RottPaws]

Tell us a little about the table(s), such as fields/datatypes, and maybe post the SQL. That should help us to help you.

You also might want to check out

http://www.tek-tips.com/faqs.cfm?spid=181&sfid=1655

to get better help in the future.

_________
Rott Paws

...It's not a bug. It's an undocumented feature!!!

 

[justlearning2003]

Hi,
I apologize for not explaining the post clearly. Here is the SQL, I think it may a divide by zero issue but I cannot find it.

TRANSFORM Sum([tblstjastats]![i_acd_time]+[tblstjastats]![i_acw_time]+[tblstjastats]![i_acd_other_time])/Sum([tblstjastats]![acd_calls]) AS [=AHT]
SELECT tblstjastats.logid
FROM tblstjastats
GROUP BY tblstjastats.logid
PIVOT tblstjastats.fdate;

Thanks

 

[RottPaws]

Unfortunately, I'm not very knowledgeable about crosstab queries, so I can't help much. I wonder though, if it has something to do with the 'AS [=AHT]' part of the query or, as you said a divide by 0 problem.

Try doing a select query on the the sums you are using for the quotient calculation and see if the divisor is 0 in any or the rows that are returned.

_________
Rott Paws

...It's not a bug. It's an undocumented feature!!!

 

[justlearning2003]

Thanks for you time RottPaws, I will try the select query.

 

[missinglinq]

Like Rott Paws I'm not very knowledgeable about Cross Tab Queries, but VBA follows most of the conventions of all of Microsoft's Basic languages, which means that:

1) Division by zero always generates an error message "Division by Zero" is illegal (doesn't make sense, is a waste of time, etc).

2) "Overflow" error, if I remember correctly, always means that the stacks in memory are set to low i.e. the area set aside in Ram to hold the incidental data during calculations manipulations (as in a Cross Tab Query) is insufficient.

With the advent of the Pentium II, II, IV, etc. I haven't seen this kind of an error message in eons. But if I remember correctly, it means you have to make some adjustments in your stack statement in the config.sys file. Maybe someone else here can give you a bit more precise instructions concerning this.

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin