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!