
April 23rd, 2008, 09:16 AM
|
|
Registered User
|
|
Join Date: Apr 2008
Posts: 2
Time spent in forums: 57 m 21 sec
Reputation Power: 0
|
|
If statement or switch case
I am working on a tax calculation program. i want to use multi if statement in the manner below:-
if sex=Male
and income>110000 and income<=150000
then tax=(income-110000) *10
elseif if sex=male
and income>150000 and income<=250000
then tax=(income-150000)*20+4000
elseif sex = male
and income>250000
then tax(income-250000)*30+24000
Please tell what will be the proper syntax for this problem in access and where to write this code.
Thanks in advance.
|