This is going to sound flippant I'm afraid, but dividing by zero is baaaad. *s* So your "workaround* is actually error protection, IMHO.

>This is a puzzling problem. We have a select statement which includes various calculated columns. We are noticing that if the result of even one of the calculations is a division by zero, the entire record is dropped in the final result. Has anybody else run into this problem? Any insight would be helpful. We solved the problem by including iif's in the divisor protion of the calculations, but it sure is a pain in the you-know-what to do that.
>
>Binoy W.