Improve company productivity with a Business Account.Sign Up

x
?
Solved

Access If else if syntax problem

Posted on 2009-05-08
4
Medium Priority
?
1,242 Views
Last Modified: 2012-05-06
Please help with troubleshooting my expression.

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]))

Open in new window

0
Comment
Question by:kgittinger
  • 2
  • 2
4 Comments
 
LVL 120

Accepted Solution

by:
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

by:kgittinger
ID: 31579529
Looks great.  Thank you!
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 24338243
did you also try did the shorter version?
0
 

Author Comment

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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
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 …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question