Minimum Charge Query

  • Thread starter Vinnie via AccessMonster.com
  • Start date
V

Vinnie via AccessMonster.com

Hi,

I've got a query that calculates a commission on a transaction, but there is
a minum charge that I can't seem to incorporate.

In other words, my calc in Excel would be =IF((TransactionValue *
CommissionRate) < MinimumCharge, Minimum Charge, TransactionValue *
CommissionRate)

But I don't know to do this in my access query, in the Field I just have:
(TransactionValue * CommissionRate)

Any help much appreciated!
 
P

pietlinden

Vinnie said:
Hi,

I've got a query that calculates a commission on a transaction, but there is
a minum charge that I can't seem to incorporate.

In other words, my calc in Excel would be =IF((TransactionValue *
CommissionRate) < MinimumCharge, Minimum Charge, TransactionValue *
CommissionRate)

But I don't know to do this in my access query, in the Field I just have:
(TransactionValue * CommissionRate)
Click to expand...
Just change IF to IIF

IIF works exactly the same way.
 
Top