Divison by zero error message

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

Guest

Hi

I run a query where one field works out BMI (i.e. (height / (weight x
weight))/10000). This works fine and has done for loads of queries. When I
try to put in the criteria field >18.5 and <30.5 and try to run the query it
comes up with the error message 'Divison by Zero'. If I remove the criteria
it is quite happy and runs the query. I have tried this criteria with other
queries and it works fine, so it must be a problem with this one query, even
though it used to work. Anyone any ideas what the problem is?

Thanks
 
You'll need to post the query's SQL statement so that we can see what you're
trying and what is not working.
 
Back
Top