>Ok then I'm not sure of the best way to accomplish this. I need to add an option to only include records where OpenQty < > 0.
>
>
>

Use CTE or derived table approach as I posted.

>>You can not use fields created in the query in the WHERE clause. The only place where you can use new fields is ORDER BY clause.
>>
>>You may either repeat the same condition in the where clause that creates this field or remove this condition from your original query, use your original as derived table or CTE and add an extra condition to it.