I need help converting crystal syntax over to access.



Calculate the PRICE and QTY:

NVL(ROUND((SH_PRICE - (SH_PRICE * (SH_TRADE_DISC / 100))),6),0) PRICE,