Expression Problem in Query 1

[robcarr]

Dear All,

I am wanting to use this formula to calculate a field

SLAHit: IIf([AHTITems]<[itemAHT],100,0)

I get an Error in the query result, the problem I believe is AHTItems is an expression, so how do I use this in the same query.

As AHTItems calculates the AHT for the item, and SLAHIT, calculates wether or not SL was hit, by checkeing AHTITems against actual target.
Can someone let me know how to use an expression result inside another expression.

Thanks



Hope this is of use, Rob.

 

[lespaul]

if you mean it's a calculated field in the same query, I don't think you can. You need to replace AHTItems with the formula used to calculate AHTItems.

Leslie

 

[robcarr]

super, I knew it was easy that worked a treat


Hope this is of use, Rob.