Gasman
Enthusiastic Amateur
- Local time
- Today, 07:10
- Joined
- Sep 21, 2011
- Messages
- 16,552
Now crossposted at https://www.utteraccess.com/topics/2066757?post=unread
Solved Combining IIf Statements
- Thread starter dullster
- Start date
We got it worked out. I want to post the end result expression then I'm marking this a solved.
IIf([tblEmployees].[Marital Status]=1 And [Basic Salary]>25727,[Basic Salary]-[Lower],IIf([tblEmployees].[Marital Status]=2 And [Basic Salary]>17780,[Basic Salary]-[Lower],[Amount from Column A]))
IIf([tblEmployees].[Marital Status]=1 And [Basic Salary]>25727,[Basic Salary]-[Lower],IIf([tblEmployees].[Marital Status]=2 And [Basic Salary]>17780,[Basic Salary]-[Lower],[Amount from Column A]))
The saga continues:
Make a negative number a "0"
I have a query expression with some of the results being a negative numbers that I wish to change to a 0. I have Salaries minus several deductions created several "Employees" to be negative which means they get a standard deduction so I want the results to be 0 instead of negative. Net Wage...
www.access-programmers.co.uk
Thank you for remembering me. Actually it doesn't continue, I have another question about the DB.
I'm starting to find any new questions that I have, may not be welcomed here or at least by you.
Either way let me know and if you prefer not to help, I'll find somewhere else for help. Thank you plog.
I'm starting to find any new questions that I have, may not be welcomed here or at least by you.
Either way let me know and if you prefer not to help, I'll find somewhere else for help. Thank you plog.
- Local time
- Today, 07:10
- Joined
- Feb 19, 2013
- Messages
- 17,396
@dullster I think the problem is you ask vague questions with incomplete data and approach a problem one step at a time without giving context to the overall requirements. As a result your threads have 40+ posts when it is likely it could have been resolved with 3 or 4 posts, saving you and us time.
Similar threads
