Help Required Urgently

[ashishkukreja]

Commission: IIf([Amt]<=10000,30), IIf(Int([Amt]/1000 Between 10000 And 50001)*3.5+3.75)

What I required to do is that when amount is greater than or equal to 10000 than Amt multiply by 30 simply.
and when amount is between 10000to 50001 than Amt/1000 multiply by 3.5+3.75

means that when amount is 15000 than according to per 1000 it will be calculated.

please dear help me out in this I required it very very urgently.

Please Please Please Please. ....................................

 

[stopher]

Begging for help and claiming "Urgent" is not the best way to endear yourself towards potential contributors.

Take a look at the syntax for IIF in Access help
IIf(expr, truepart, falsepart)

Also take a look at the Switch function which may be more appropriate.

Your expression doesn't follow this format at all. Moreover, your logic contradicts itself.

What I required to do is that when amount is greater than or equal to 10000 than Amt multiply by 30 simply.
and when amount is between 10000to 50001 than Amt/1000 multiply by 3.5+3.75

means that when amount is 15000 than according to per 1000 it will be calculated.

Do you really mean:
if Amt less than or equal to 10000 then return Amt*30
if Amt greater then 10000 and less than 50001 then return ((Amt*3.5/1000)+3.75)

Then the expression should be:
IIF([Amt]<=10000,[Amt]*30,IIF([Amt] between 10000 and 50001, (Amt*3.5/1000)+3.75,otherCalcExperssion))

Note the otherCalcExpression. This is where you need to put what you want returned if Amt >50001.

hth
Chris

 

[ashishkukreja]

Thanks

Thankyou for your reply