Search results

Thank you. This is starting to make sense.

Ah, yes, I know to how to open a VBA editor. I did not know the difference between a Function and a sub so I googled it. I need a function. I am new to VBA so I was thinking it was pasted into the sql. When you asked that it dawned on me what I was not getting.

Isaac wrote me a sample VBA. Where does this language go? Does it go into the query itself or into the sql version. I'm trying to learn where the vba would go? https://www.access-programmers.co.uk/forums/threads/combining-iif-statements.333918/post-1961313

I have 4 IIF Statement that calculate State Taxes for marital status: Married, Single and greater than > income, or less than <income for each marital status. All 4 Statements end in -([Exemption credit]) or -([Exemption credit])). They work individually they way they are supposed to. When I...

I didn't know that the IIF only condones three arguments. Probably exactly my problem, thus why I need to graduate to vba. Thank you.

Marital Status is from table [Marital Status] Married=1, Single=2 Short text and is required; Basic Salary is from [tlbEmployees] Currency is required; Lower is from [tblpayrolltaxes] Currency is required; [Exemption credit] if a calculated Currency field in the [QryStateTax] I have all...

Is this too simple? IIf([tblEmployees].[Marital Status]=1 And [Basic Salary]>25727,[tblEmployees].[Basic Salary]-(([tblEmployees].[Basic Salary]-[Lower])*0.2)-([Exemption credit]),IIf([tblEmployees].[Marital Status]=2 And [Basic Salary]>17780,[tblEmployees].[Basic Salary]-(([tblEmployees].[Basic...

Thank you. People say it's easier but I'm scared to start as it is foreign ground but I will give it try and come back. Thank you.

I marked it as solved which I thought was what I was supposed to do but If I'm supposed to do something else, please let me know. I did that because one person just keeps making rude comments about doing it sql, which i don't know how to do and that really is their only contribution which just...

I would love to switch to VBA. I'm never written one before. What is my first step or should i watch videos?

I seems that no matter what I post, I'm going to get criticized instead of helped.

I agree. It's time. How do I start? Do I need all my IIf's that work put together first? I'm not sure where to start.

My apologies

Welcome, I'm new here but I've seen alot

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