By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,286 Members | 1,634 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,286 IT Pros & Developers. It's quick & easy.

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

P: 1
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
Jul 1 '10 #1

✓ answered by MikeTheBike

@aby242002
Hi

You will need the Immediate If statement like this

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

Any question/problems, please post back.

MTB

Share this Question
Share on Google+
1 Reply


Expert 100+
P: 636
@aby242002
Hi

You will need the Immediate If statement like this

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

Any question/problems, please post back.

MTB
Jul 1 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.