I need help with building an expression in Access. I’m new to SQL so I’m wondering if someone can create the expression for me?
See the attach excel file for my table
This is what I need:
If CODE = BVSTKUOM then QUANTITY_ONHAND and
If CODE <> BVSTKUOM then QUANTITY_ONHAND / QYT_FACTOR
On the <> part if QUANTITY_ONHAND / QYT_FACTOR is 42.54 then it should be rounded up to the nearest full number (e.g. 42.54 = 43). Also if QUANTITY_ONHAND / QYT_FACTOR <= 0.99 then it should be 0