if statement or switch case
I am working on a tax calculation program. i want to use multi if statement in the manner below:-
and income>110000 and income<=150000
then tax=(income-110000) *10
elseif if sex=male
and income>150000 and income<=250000
elseif sex = male
Please tell what will be the proper syntax for this problem in access and where to write this code.
Thanks in advance.
Re: if statement or switch case
You would have to create a module by clicking on module on the left of the window. This allows you to write vba (Visual Basic for Applications) code. Create a function called TaxCalc or anything else you want to name it and make it public. That way it can be reached by queries, etc.
Public Function TaxCalc(Income as single) as single
your code here
This accepts the income as a parameter and calculates a result. If you name the result TaxValue, your last statement in the function would be
|All times are GMT +5.5. The time now is 00:52.|