Numeric Field Overflow

[i1055]

Could someone please explain what causes the &quot;numeric field overflow&quot; error??<br>
<br>
I have a table with no more than 250 rows, 4 fields, and I set up a select query to exclude certain criteria and sum one of the fields, and I receive the error. Oddly, if I make any change to the query, then undo the change, then save the query, it runs fine. But if I try to run it again, I get the error.<br>
<br>
Thanks for your advice.

 

[WP]

Are any of your fields integer ?<br>
<br>
If so, try changing them to Long. <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[rochelle]

Numeric field overflow means that you are trying to assign a number to a variable that is larger than that type of variable is designed to accomodate. Change the type of variable.<br>
<br>
I would look at the variable that is supposed to receive the total of the field you are summing. Check how it's been DIM 'd and then check its maximum.<br>
<br>
Rochelle