Minimum Charge Query

[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!

 

[pietlinden]

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)

Just change IF to IIF

IIF works exactly the same way.

 

[Vinnie via AccessMonster.com]

Thanks a lot!

Hi,

[quoted text clipped - 7 lines]

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

Just change IF to IIF

IIF works exactly the same way.