Search results

The ? are 0. I tried this and still getting Syntax errors. IIf([tblEmployees].[Marital Status]=1 Or [tblEmployees].[Marital Status]=2 And [tblEmployees].[Basic Salary]<[tblpayrolltaxes].[Lower],IIf([tblEmployees].[Basic Salary]>[tblpayrolltaxes].[Lower],([tblEmployees].[Basic...

If Married (1) and the basic salary is lower than a certain amount in the Lower field, return 0. If Single (2) and the basic salary is lower than a certain amount, then Basic salary - the Lower amount.

Yes! but then i discovered I needed the greater then calculation also. This is what is did and the < are not returning 0. IIf(([tblEmployees].[Marital Status]=1 Or [tblEmployees].[Marital Status]=2) And [tblEmployees].[Basic Salary]<[tblpayrolltaxes].[Lower],"0",IIf([tblEmployees].[Basic...

So should I try a "1 or 2" and eliminate the 2nd statement? I'll try it. I thought if it was 2 different criteria I had to have it in there.

Marital Status is 1 or 2

I have 2 IIF statements that work individually, when I combine them I get this error, The expression you entered has a function containing the wrong number of arguments. What am i doing wrong? IIf([tblEmployees].[Marital Status]=1,[tblEmployees].[Basic...

I'm definitely not that advanced.

I tried it, I'm getting "The expression you entered contains invalid syntax, or you need to enclose your text in quotes". It highlights the comma before the 2nd IIf.

I have the calculations for all 3 level working by this. Taxes 12760: IIf([tblEmployees].[Basic Salary] Between 0 And 12760,[tblEmployees].[Basic Salary])/([tblEmployees].[Salary Pay Period]) Taxes 25520: IIf([tblEmployees]![Basic Salary] Between 12760 And 25520,[tblEmployees].[Basic...

This gave me errors also.

I'm doing it in a query

If i get it working, I'll change it by a penny.

I pasted that code in, i still get a calculation for people not in between Min and Max. Should i change my Min and Max to Minimum and Maximum to Top and Bottom?

I corrected it to read, Taxes: IIf([tblEmployees]![Basic Salary] Between [tblpayrolltaxes]![Min] And [tblpayrolltaxes]![Max],[tblEmployees].[Basic Salary]-[tblpayrolltaxes]![Min],0) It is still calculating people out side of the Min and Max

Taxes for 25520: IIf([tblEmployees]![Basic Salary] Between [tblpayrolltaxes]![Min] And [tblpayrolltaxes]![Max],[tblEmployees].[Basic Salary]-[tblpayrolltaxes]![Min]) My initial issue was splitting the Fed by different income levels which was splitting Fed taxes by filing Joint and Individual...

I tried removing the last part that calculates tax and my results didn't change. Taxes for 25520: IIf([tblEmployees]![Basic Salary] Between [tblpayrolltaxes]![Min] And [tblpayrolltaxes]![Max],[tblpayrolltaxes]![Min]-[tblEmployees]![Basic Salary]/[tblEmployees]![Salary Pay Period])

If i take out the iif(), i get all kinds of errors. I now have this now and it is calculating for everyone, not just the Salaries that are between the Min and Max. I'm thinking maybe i need another set of () some where. Taxes for 25520: IIf([tblEmployees]![Basic Salary] Between...

If Basic Salary is between the Min and the Max, I want it to Calculate the tax. I have this statement, when i hit run I get, "The expression you entered contains invalid syntax. You may have entered a comma without a preceding value or indentifier" and it highlights "between". Taxes...

I think i was making this harder than it needed to be. I woke up in the middle of the night and created a query with multiple criterias and the 12 or 26 pay periods to match and it worked perfectly. The pay check amounts would fall between the minimum and maximum, the joint filing would match...

I want the tblEmployees.Salary Pay Period of 12 or 26 to match tblpayrolltaxes.Payroll Period, tblpayrolltaxes.Filing Status to match tblEmployees.Filing Status and tblEmployees.Total of Pay Check to be between the tblpayrolltaxes.Minimum Income and Maximum Income. Table screen shots attached