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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overflow error on calculate field in query - Help Please 1
Numeric Field Overflow Error 5
Numeric Field Overflow 1
Numeric Field Overflow when appending date - how to convert it to text 1
Overflow 1
"Overflow" message in UNION query 4
Using query to make a table 3
Overflow Message 9

Back
Top