Search results

  1. M

    Selective/if fields

    Thanks, it works for me!
  2. M

    Selective/if fields

    I have a query that has the follwing fields: Gross Payment :Currancy Tax Discount: Boolean (Yes/No) I want to create a new field called Tax Deducted that if the tax discount is no, the Tax deducted = Gross Payment * (22/100) but if tax discount is yes, then Tax Deducted = 0. I'm not sure if...
Back
Top Bottom