Overflow message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Whenever, you have division, you should always check for zero since division
by zero always gives error in Access (and in Mathematics).
 
Back
Top