Hi John,
There's HAVING clause which allows to apply conditions to the grouped values. Try
HAVING yCurrentValue<>0.00
>I have a view of a table that contains a yAmount field.
>I left join to a child table that contains adjustments to the parent. It too has a yAmount field.
>
>I sum the values from both tables to a field in the view named yCurrentValue.
>
>In the where I have: where yCurrentValue<>0.00
>
>I receive the error, yCurrentValue is not found
>
>Is there a way to where on a calculated field?
>
--sb--