Search results

  1. Q

    Combine 2 field in 1 row

    I wish combine 2 table field into 1 field in the report Bank code ID Bank Currency 1 UOB RM 2 PBB RM 3 UOB USD Table Product ID Product Unit Price 1. AAA 6.40 2. BBB 3.00 Report as : Product Price AAA RM6.40 BBB...
  2. Q

    Calculation valid from specify time

    I wish to create a query : Only calculation OT start from 6:00pm, but it not working with below. Please advice. tks. OT : IIf([Production Details]![End Time]>18,0,Round(([Production Details]![End Time]-[Production Details]![End Work])*24,2))
  3. Q

    #Num! shown calculation

    OT Hrs: IIf([Production Details]![Depositing Qty Overtime]<30,"0",Round(([Production Details]![End Time]-[Production Details]![End Work])*24,2)) The result was show properly. But when I used it the OT Hrs to multiply the OT quantity. The answer correctly calculation execpt the OT value was 0...
  4. Q

    Calculation of 2 amount if some of the field was null

    Calculation : In the event the null, is will become 0. OT Qty: Nz([Qty(Overtime)-Nz([Qty(Work Hour)]) Is work to calculated the OT amount. How to set the value become zero in the event the the Qty(Overtime) was null.
Top Bottom