#error in query

[scriggs]

Hi

I have a query which is left joined so some fields have no data. Also some fields have a zero in them.

I am trying to perform a calculation like a/b and if a or b is missing then I get an #error.

I have tried iif(isnull(a),0,a/b) and nz(a,0) but still get errors.

Any ideas?

 

[lespaul]

are any of your B values zero? you can't divide by 0.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins