Carried forward balance

[fisseha]

Someone please help!

I am trying to do employee tax for the following:

			No. Salary Range (ETB) Tax Rate Deduction (ETB) 1. 0 - 600 Birr Non-Taxable - 2. 601-1,650 Birr 10% 60 Birr 3. 1,651 - 3,200 Birr 15% 142.50 Birr 4. 3,201 - 5,250 Birr 20% 302.50 Birr 5. 5,251 - 7,800 Birr 25% 565 Birr 6. 7,801 - 10,900 Birr 30% 955 Birr 7. Over 10,900 Birr 35% 1,500 Birr
			Please I am a complete novice in VBA and your help would be highly appreciated if the code would be just copy and paste. Thanks in advance

[ranman256]

You don't need vb. you can do it with queries.
the table above needs the range in 2 fields, SalaryStart,SalaryEnd.
the query will have the data table and the tax range table,
criteria EMP.salary >= tTaxRate.SalaryStart and EMP.salary <= tTaxRate.Salaryend

[fisseha]

I am totally lost and appreciate If anyone's help in this matter. Preferably in VBA please.

[Homegrownandy]

You've been given the answer. It's a basic query that requires no VBA. Sorry to be blunt, but investigate Ranmans sugestion. Ask away if you have trouble...

[ssanfu]

@fisseha,
First, welcome to the forum.

Next, you didn't ask a question. Remember, you are working on the dB - we have never seen it and don't know what you are having problems with.

We need to know what the problem is, the data you are working with and the expected results.
It looks like if a salary is in the range of 601-1,650 Birr, the tax rate should be 10%. But for the deduction to be 60 Birr, the salary would be 600Birr, which is non-taxable.

Please explain your business like you would to a 10 year old, then state your question with the raw data and the expected results.

[fisseha]

Thanks so much for your response. What I was trying to do is that since the salary info is there when I enter hours worked access to calculate and give me net pay if possible.
I appreciate you help.

[fisseha]

Well I tried it and didn't work. If it is basic show it in practice sorry to be blunt.

[andy49]

create a table tbltax with fields
Taxlower
Taxupper
taxrate

Then the query should look something like

SELECT tblsalary.salary, tbltax.taxrate
FROM tbltax, tblsalary
WHERE (((tblsalary.salary)>[tax]![tblsalarystart] And (tblsalary.salary)<[tbltax]![salaryend]));

You can use a similar technique to get deduction then use a final calculated column to do the maths

[CJ_London]

I think the etb is a fixed amount paid irrespective if the tax rate i.e.

salary=3000
so in range 1651-3200
ergo tax rate=15%; =450+142.5 etb; =592.5 total tax; =net pay 2407.5

[Homegrownandy]

that's not blunt, you should ask if you don't know.