Numeric Overflow message

[Manuel]

There's a query in my database which sometimes will not
run - instead I recieve the following message:

"Numeric field overflow."

When I click Help, I get the following:

"Error # 3349.
The data in a Btrieve field is too large to represent in
your application."

The query is based off a linked table. I can open the
linked table and view the data - no problem. I'm only
pulling one field from the table (a numeric field) - I'm
counting this field by selecting the Sum function (the
symbol that looks like an "E"), and selecting "Count" from
the "Total:" row.

Why do I get this message? How can I prevent it?

Your help is much appreciated.

Thanks,

Manuel

 

[Michel Walsh]

Hi,


Your sum may produce a number too large, too big, for the precision or
for the data type it used to represent it.


Hoping it may help
Vanderghast, Access MVP