[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# Access If else if syntax problem

Posted on 2009-05-08
Medium Priority
1,229 Views

I have been asked to write the following statement and am having syntax problems:

The first segement below is my instruction and the second is what I have entered in the expression builder.
``````[over60]
If debits(90)>=BAL
Then 	If (BAL-Over30)>0
then Over60=(BAL-Over30)
else Over60=0
Else over60=(Debits(90)-over30)
Endif

60To90DayDebits:Sum(IIf([Query1]![SumOf90To120DayDebits]>=[Dbo_Accounts!Balance], IIf([Dbo_Accounts!Balance]-[Query1]![SumOf30To60DayDebits]>0, [Dbo_Accounts!Balance] - [Query1]![SumOf30To60DayDebits]), 0),[Query1]![SumOf60To90DayDebits]-[Query1]![SumOf30To60DayDebits]))
``````
0
Question by:kgittinger
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2
• 2

LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 24338138
test this

60To90DayDebits:Sum(IIf([Query1]![SumOf90To120DayDebits]<[Dbo_Accounts!Balance], [Query1]![SumOf60To90DayDebits]-[Query1]![SumOf30To60DayDebits],IIf([Query1]![SumOf90To120DayDebits]>=[Dbo_Accounts!Balance] And [Dbo_Accounts!Balance]-[Query1]![SumOf30To60DayDebits]>0, [Dbo_Accounts!Balance] - [Query1]![SumOf30To60DayDebits], 0)))

or this shorter version

60To90DayDebits:Sum(IIf([Query1]![SumOf90To120DayDebits]<[Dbo_Accounts!Balance], [Query1]![SumOf60To90DayDebits]-[Query1]![SumOf30To60DayDebits],IIf([Dbo_Accounts!Balance]-[Query1]![SumOf30To60DayDebits]>0, [Dbo_Accounts!Balance] - [Query1]![SumOf30To60DayDebits], 0)))
0

Author Closing Comment

ID: 31579529
Looks great.  Thank you!
0

LVL 120

Expert Comment

ID: 24338243
did you also try did the shorter version?
0

Author Comment

ID: 24338397
Both produced the same results.  Thanks you again for all of your help.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
###### Suggested Courses
Course of the Month14 days, 7 hours left to enroll