overflow!

[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

 

[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

 

[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,

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

[quoted text clipped - 10 lines]

thank you

 

[Tom Lake]

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,

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

Tom Lake