overflow!

  • Thread starter mohsin via AccessMonster.com
  • Start date
M

mohsin via AccessMonster.com

Hi there

SELECT qrtrimdateformat.MSC, qrtrimdateformat.Date, Avg(qrtrimdateformat.
HOFailIntra) AS AvgOfHOFailIntra
FROM qrtrimdateformat
GROUP BY qrtrimdateformat.MSC, qrtrimdateformat.Date;

I run a queries to get an average value, but OVERFLOW!! was appeared,

my data is non with 0, and the HOFailintra in %.

any guide how can i solve this OVERFLOW!

thank you
 
M

Michel Walsh

It seems that SUM(HOFailIntra) exceed the maximum value that can be stored
into its declared data type (depends on what the table design said it is),
which is possible if it already has one record with that maximum value in
it.


Vanderghast, Access MVP
 
M

mohsin via AccessMonster.com

Yes you a correct,

after detail checking of all those data, (from table design) some of values=0,
so when i make a div, it will gave #error in some row.

can you help me, how can i run a queries when A/B where either A or B (or
both) is =0, then the value of result will be = 0,




Michel said:
It seems that SUM(HOFailIntra) exceed the maximum value that can be stored
into its declared data type (depends on what the table design said it is),
which is possible if it already has one record with that maximum value in
it.

Vanderghast, Access MVP
Hi there
Click to expand...
[quoted text clipped - 10 lines]
thank you
Click to expand...
Click to expand...
 
T

Tom Lake

mohsin via AccessMonster.com said:
Yes you a correct,

after detail checking of all those data, (from table design) some of
values=0,
so when i make a div, it will gave #error in some row.

can you help me, how can i run a queries when A/B where either A or B (or
both) is =0, then the value of result will be = 0,
Click to expand...

=IIf([A] * = 0, 0, [A] / )

Tom Lake
 
Top