Web Development

Ask something
Question Locked

Please help!!!Query

0 helpful
2 replies

by alexeye2006

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a simple Access 2000 database that has a table.this table has gross salary field.i want to calculate income tax from this field based on criteria.because income tax as you all know varies with income please help!!!

2 replies

by tony hopkinson

Select Income,
Case When [income] < 20000 Then [Income] * 0.2
Else
(20000 * 0.2) + (([Income] - 20000) * 0.4)
End
as [Income Tax]
From MyTable

For example.

You could really go to town and put the rates and bands in another table. You need to look at if from SQL though not the query builder gui.

HTHs

This discussion is closed to new replies.