Overflow message

W

Wylie C

I have a db with 495 records in the table. I have two fields that I am using
in a
query to calculate averages using the formula Ave:[H]/[AB]. Both fields are
long integers at the table. The query runs OK if I do not try to sort on this
field but if I
try to sort on this field I get an Overflow msg.

Any help as to why I may be getting this msg and/or how to correct it would
be greatly appreciated.

Thank you.
 
V

Van T. Dinh

Whenever, you have division, you should always check for zero since division
by zero always gives error in Access (and in Mathematics).
 
Top