Conditional Expression

[blacktide]

If my total = ...................

If my total = $0.00 to $500.00 I need to multiply it by 4% anything over $500.00 I need to multiply it by 5%. Is there an easy way to accomplish this?

Mike

 

[Rich]

Iif([MyField]<500,[MyField]*.4,[MyField]*.5)

 

[Pat Hartman]

How about this:

Iif([MyField]<=500, [MyField]*.04, [MyField]*.05)

 

[blacktide]

forum placement mistake

It seems that I misplaced my post. I should have posted this in the Reports Forum. Sorry about that.

I also asked the Office Administrator for some clarification on this report and it seems that I was misinformed on how it was supposed to work. It isn't as simple as $500.00 or less multiply it by 4% and if it is more than $500.00 multiply it by 5%.

Maybe this will help explain a little more. Lets say my grand total equals $2500.00. Well the first $500.00 of that will be multiplied by 4% and the remaining $2000.00 will be multiplied by 5%. Does this make more sense? Well actually why they are doing it this way makes no sense to me, but who am I??? hahahahaha

Thanks again guys!!!!

Michael

 

[Pat Hartman]

You can do it but I would suggest writing a function. You can then use your function in the query.

 

[blacktide]

Solution

You can do it but I would suggest writing a function. You can then use your function in the query.

Pat,

I know it has been months, but I finally got back around to my problem (as you can tell it wasn't that pressing). Here is the solution: =iif( [TotalCommission] <= 500, .04 * [TotalCommission], (500*.04) + ( ([TotalCommission]-500) * .05 ) )

Thanks to clippit at www.utteraccess.com