Calculation of 2 amount if some of the field was null

[QuChe Yvonne]

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.

 

[John Big Booty]

Welcome to the forum.

Your Nz() syntax looks a little off, try;

Nz([Qty(Overtime)],0)-Nz([Qty(Work Hour)],0)

Also avoid using spaces and other special characters in your Object and Control names, limit yourself to alpha and numeric characters and the under score so Qty(Overtime) would be Qty_Overtime or simply QtyOvertime.

 

[QuChe Yvonne]

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

 

[QuChe Yvonne]

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 :
Product Price
AAA RM6.40
BBB USD3.00
Not working with this : =[Bank code][Currency] &""&[Product][Unit Price]

 

[John Big Booty]

Re: 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 :
Product Price
AAA RM6.40
BBB USD3.00
Not working with this : =[Bank code][Currency] &""&[Product][Unit Price]

Please limit your questions to the one thread