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. - 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,"")))),""))
2  1937 
I'm an Idiot!!! Here is the Correct Code. - 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,"")))),""))
Thanks for posting back with the correct code!
Regards,
Scott
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Mike Knight |
last post by:
(I've also posted this problem on microsoft.public.excel.programming)
I have a MS Access 2003 Database named "AS400 Fields.mdb". This
database contains links to tables on an AS400.
In MS...
|
by: hari krishna |
last post by:
hi,
I want to send the data from dataset information to Excel through ASP.Net.
there will be no XL installed on web server. web server is win 2000 server
machine. I am using visual basic code in...
|
by: sparks |
last post by:
We get more and more data done in excel and then they want it imported
into access.
The data is just stupid....values of 1 to 5 we get a lot of 0's ok
that alright but 1-jan ?
we get colums...
|
by: garry.oxnard |
last post by:
Can anyone help me to solve a problem which involves switching from
Access to Excel (then back to Access) programatically please?
I have an Excel template which, on open, also opens an Access...
|
by: Daedalus |
last post by:
I need to make it so that a DB of a membership list I have can send the sum value of a column to a cell in a Excel spreadsheet.
Basically:
I have in Access a membership database which, among...
|
by: stronghold888 |
last post by:
Hello everyone,
I created a database in Access and on my form, I inserted a button that exports data into a ready Excel template. The export works fine, but I have one problem and it's from my...
|
by: =?Utf-8?B?TEJU?= |
last post by:
Good Day,
I have a web application created using ASP.NET (with VB.NET). The
application allow user to browse Excel raw data file then the program will
grab data from the file to perform further...
|
by: admin |
last post by:
Hi Everyone
I just released a new version of SQL Excel - it is a freeware add-in
for excel (http://www.sqlexcel.net). There are several good
enhancements in this release and I think it is great...
|
by: =?Utf-8?B?YzY3NjIyOA==?= |
last post by:
Hi all,
I have a question for you.
I have a .csv file which has many lines of data.
Each line has many data fields which are delimited by ",".
Now I need to extract part of data from this...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
