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

Excel IF statements to Access IF statements: Need Help Please

P: 55
So here is my issue. I have a multiple IF statement in Excel 2003, which I am trying to convert to Access 2003. My error in Access has to do with the OR function , which is taking place inside the IF statement. Below you will find the IF statement. Any help getting this same statement to work in ACCESS is greatly appreciated.

Thank you.

Expand|Select|Wrap|Line Numbers
  1. Total Days in Period: IIF( [Accrual Method] ="A", [Next Paydate] - [Accrual Start Date] , IIF(OR( [Accrual Method] = "D", [Accrual Method] ="E"),360/IIF( [Payment Frequency ] ="S",2,IIF( [Payment Frequency ] ="Q",4,IIF( [Payment Frequency ] ="M",12, IIF( [Payment Frequency ] ="A",1,"")))),""))
Sep 17 '07 #1
Share this Question
Share on Google+
2 Replies

P: 55
I'm an Idiot!!! Here is the Correct Code.

Expand|Select|Wrap|Line Numbers
  1. Total Days in Period: IIf([Accrual Method]="A",[Next Paydate]-[Accrual Start Date],IIf([Accrual Method]="D" Or [Accrual Method]="E",360/IIf([Payment Frequency ]="S",2,IIf([Payment Frequency ]="Q",4,IIf([Payment Frequency ]="M",12,IIf([Payment Frequency ]="A",1,"")))),""))
Sep 17 '07 #2

Scott Price
Expert 100+
P: 1,384
Thanks for posting back with the correct code!

Oct 5 '07 #3

Post your reply

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