Divison by zero error message

D

D Stretton

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
 
K

Ken Snell [MVP]

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