I want to use IF and Else Funtion in Query How I can use IF and Else funtion in Query

[aby242002]

I want to identify the an amount is grater than A amount same time want to calculate other percentage if that is less than A amount

[MikeTheBike]

I want to identify the an amount is grater than A amount same time want to calculate other percentage if that is less than A amount

Hi

You will need the Immediate If statement like this

PCT:IIF([Your Field Name]> Value, TrueCalcHere,Fa lseCalcHere)

Any question/problems, please post back.

MTB