<div>
<div class="content wysiwyg-content">
Hello:<br />
<br />
I am using the following expression in an Access query to generate a proportion defective<br />
<br />
(QNs_LV_FV_qry.[SumOfDefec<wbr />tQty (ext)]/Shipments_FV_qry.Su<wbr />mOfDeliver<wbr />y_Qty)*100<wbr />0000 AS QN_PPM<br />
<br />
Sometimes, however, there are no defects, so the above expression returns a null. I would like it to return a zero in such cases. <br />
<br />
Thanks
</div>
</div>


Hello:

I am using the following expression in an Access query to generate a proportion defective

(QNs_LV_FV_qry.[SumOfDefectQty (ext)]/Shipments_FV_qry.SumOfDelivery_Qty)*1000000 AS QN_PPM

Sometimes, however, there are no defects, so the above expression returns a null. I would like it to return a zero in such cases. 

Thanks

I would like my SQL to return a Zero if a Null is returned

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.