Error message

[Beth]

Can anyone tell me what it means when I get an "Overflow"
error messasge while executing a query??? I cannot find
an explanation anywhere. I am just trying to create a
query which sums account holdings and then calculates a
percentage of the total. Simple! Easy! But when I run it
I keep getting the "Overflow" message. I do not
understand.

 

[Michel Walsh]

Hi,

You probably exceed the maximum value the data type can handle. 24*60*60
as example, exceed a small integer limit. 24.0 * 60.0 * 60.0 would succeed,
since a float has a much larger limit.

Hoping it may help,
Vanderghast, Access MVP