You need to name your new field differently.
>A simple question about use of the HAVING phrase. Here's a sample SELECT statement
>
Select Partno ;
> , Sum (RealCost) As RealCost ;
> , Sum (PostedCost) As PostedCost ;
> , Sum (RealCost - PostedCost) As Variance ;
> , Sum (1) As Count ;
> , Sum (NItems) As NItems ;
> ;
> from c_Source ; ;
> group By 1 ; ;
> into Cursor c_Browse Readwrite
>I'd like to be able to reference the RealCost field in the result in the HAVING phrase ... HAVING RealCost # 0 ... but I get an error message because of the name conflict with the field RealCost in the source cursor.
>
>How can I refer to the RealCost field in the result cursor (in the HAVING phrase)?
>
>Yes, I know I could choose a different name in the result cursor ... I'm hoping I don't have to.
If it's not broken, fix it until it is.
My Blog