I am trying to write a query (see qryGMUtility) that returns the commission that we pay on each product sales record. The commissions we pay are stored in a table called “UtilityPayout”.
Commissions are only paid when the orders are accepted by the utility, that is, the UtilityStatus="Accepted by Utility". Therefore, the value in the field “Payout” should be $0 if the UtilityStatus=”Rejected by Utility”, otherwise, the payout value should be taken from the UtilityPayout table.
Here’s one of the things that I tried without success: IIf([qrytblSalesToo].[Util
Attached is a small extract of the db with the query.
Thanks for your help and any pointers that you can give me to help me learn.
BTW, does anyone know why "TCP/IP" is showing up as a topic under "Select Topics" where I submit this question? I can't get rid of it.