Enter Parameter Value Error

[wojosh6]

I am getting an Enter Parameter Value error for both "CURR_FV" and "HC_ADD_ON" on the below query. I used the builder to create this query & it was working until I updated the query name (stupid me). Please help!

SELECT [d ML_CALC].[POS-COUNTER-PARTY],
[d ML_CALC].[POS-SEC-IDENTIFIER],
[d ML_CALC].[POS-MV-IN-USDE],
[d ML_CALC].[MaxOfBAL-OPT-REQ-AMT],
[d ML_CALC]![MaxOfBAL-OPT-REQ-AMT]/[c ML_Data_Query]![Sum Of POS-MV-IN-USDE] AS OPT_PCT,
[POS-MV-IN-USDE]*(1-[OPT_PCT]) AS CURR_FV,
IIf([POS-HELD-CURRENCY]="USD",0,IIf([POS-MV-IN-USDE]>=0,0.08,0.056569)) AS FX_HC,
IIf([POS-MV-IN-USDE]>=0,[10D HAIRCUT],[5D Haircut]) AS MARK_VOL_HC,


[CURR_FV]*([FX_HC]+[MARK_VOL_HC]) AS HC_ADD_ON,
IIf([CURR_FV]>=0,([CURR_FV]-[HC_ADD_ON]),([CURR_FV]+[HC_ADD_ON])) AS ADJ_MV


FROM [d ML_CALC] INNER JOIN [c ML_Data_Query] ON [d ML_CALC].[POS-COUNTER-PARTY] = [c ML_Data_Query].CounterParty


WHERE (((IIf([CURR_FV]>=0,([CURR_FV]-[HC_ADD_ON]),([CURR_FV]+[HC_ADD_ON])))<>0));

[wojosh6]

I'm an idiot. It was the last Criteria I added... the "<>0" thing. I removed that and all is well.

[pbaldy]

Glad you got it working. Due to the order in which clauses are evaluated, you can't use alias names in the criteria. You can repeat the calculations, though in this case that might get unwieldy. Another alternative is basing a second query on this one and putting the criteria there.