Search results

I had make a query for this both table. Just want to combine the currency beside unit price in 1 box in the report

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...

Combine multiple rows into one cell 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 ...

Hi Paul Eugin, I have attached the sample. I can the calculation OT started from 6:00pm. For those didn't overtime show 0. Please advice. Thanks Yvonne

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))

Dear ByteMyzer, Anyway do not show the #Num!?

Calculation 1 : OK OT Hrs: IIf([Production Details]![Depositing Qty Overtime]<30,0,Round(([Production Details]![End Time]-[Production Details]![End Work])*24,2)) Calculation 2 : Not OK :banghead: =Nz([OT Qty],0)/Nz([OT Hrs],0) The result still the came out #Num! in the event 0 OT.

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...

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...

Thank you very much on your comment. I will try it.

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.