Search results

Thank you. I started with Access about 35 years ago when it moved from DOS to Windows. I've built several and maintained several since then. This DB that I inherited, was created in the DOS program specifically for Towns in Wisconsin, US. It provided the data that is specific to the State of...

Thank you. I started with Access about 35 years ago when it moved from DOS to Windows. I've built several and maintained several since then. This DB that I inherited, was created in the DOS program specifically for Towns in Wisconsin, US. It provided the data that is specific to the State of...

Actually, I'm breaking it down into smaller expressions to adjust to the many scenarios. I'm not experienced in function, and had hoped I could learn, but it doesn't appear your that teacher. I hope you can learn through all of this there is more than one way to get a DB to work.

Thank you, I was starting to read about "switch". Never heard of it before. It's a new learning curve for me, bur it sounds like once you learn it, it's easier. I will review this tomorrow.

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...

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...

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

I originally asked is someone could tell me how to combine 2 working IIf statements. That was it.

My original post is the qry expressions I wrote to exactly what is in #30 except I just wanted help on getting them combined. This has really spiraled. Go back to my first post.

The tblEmployees and tblpayrolltax contain all the information. I am currently working with QryStateTax to provide the data.

No one makes more them those upper limits and I don't see it happening in my life time. Only single or married, no other options. There should never be a null. Null would be no pay check. As I said, I got all the functions to work individually. I was just hoping for someone to tell me how to...

I’m going to try one more time to explain this in detail. Single If the person is Single and their gross income is <$17780 the deduction is $6,702. If their income is between $17,780 and $73,630 the deduction is, $6,702 minus (Gross income -$17,780 x 0.12). Married If the person is Married and...

Sorry, i tried the code as is, it doesn't work.

As I read this, I assuming Dim Val As Currency should be Dim Val As Current? Let me know if I'm wrong. When I run this I get, Syntax error (missing operator0 in query expression 'Dim Val'. Dim Val As Current If Not IsNull(Marital Status) And Not IsNull([tblEmployees].[Basic Salary]) And Not...

I hate to say this but I discovered that it doesn't like the < or > [tblpayrolltaxes].[Lower] and i had to enter the actual number. I have all of these working on there own without returning 0. Could someone kindly tell me how to get them to all work as one statement...

I thought you were asking if no results then "?', which would be 0.

These are the 4 working expressions. One set for Single (2) and one set for Married (1). The all work seperately. I need to combine them to work together. IIf([tblEmployees].[Marital Status]=1,[tblEmployees].[Basic Salary]<[tblpayrolltaxes].[Lower],[tblpayrolltaxes].[Amount from Column...

Tax will be calculated off from these results. I'm trying to make it simple right now. But if Married (1) and Basic salary is > Lower, than basic Salary - Lower. Marital Status matches in tblpayrolltaxes and tbl Employees. I need both to calculate.

So I changed it to............I still get the wrong number of arguments IIf([tblEmployees].[Marital Status]=1 Or [tblEmployees].[Marital Status]=2), And [tblEmployees].[Basic Salary]<[tblpayrolltaxes].[Lower],IIf([tblEmployees].[Basic Salary]>[tblpayrolltaxes].[Lower],([tblEmployees].[Basic...

I can't get the if false 0 to work, I keep getting errors, but i will not, no one in my scenario meets that criteria. If I add the ,0 to show if false, i get the wrong number of arguments. IIf([tblEmployees].[Marital Status]=1,[tblEmployees].[Basic...