Search results

didn't know you added to my DB. I'll look at it now.

I didn't know there was a BasTaxCompute module or QryStateTax_arnelgp. Where are these?

Could you please explain what Local variables means? And what does declare and set to the cdbl() version mean and where would I do that? I reviewed what I had typed up and realized I entered it as sql code instead of following your example. Looks like the only places a problem is appearing now...

I just realized I may have copied some other stuff that shouldn't have been there. I fixed that but have a couple of questions that I will ask Isaac.

I am just starting my first VBA. Actually I think i could have had it done in less than 2 day after I started. I still trying to work through what I did incorrectly because it won't load into the query yet, but it's a work in progress. I posted what I did so see if anyone could help if you want...

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