abdo meghari
Well-known Member
- Joined
- Aug 3, 2021
- Messages
- 675
- Office Version
- 2019
Hi
I would extract details in label 6 to show me what exactly boxes and pieces .
so when enter QTY in textbox6 then should calculate pieces for each box based on textbox1,textbox2
in this case textbox6 contains 22 pieces and compare with pieces in textbox2 and in this case every 10 pieces in textbox2 will be for each box in textbox1 . so in textbox1 every box contains 10 pieces .
in textbox6 will contain 2 boxes and 2 pieces ( 10+10= 20 for two boxes , 2 pieces will be less than 10 pieces for each box so can't
show as boxes.
here is example to show result in label6 after fill textbox6
should match textbox6 with textbox3 if the QTY in textbox6 bigger than textbox3 and show plus QTY
this is less than one box contains (10 pieces) so will show 3 pieces
I hope theses pictures are clear.
thanks.
I would extract details in label 6 to show me what exactly boxes and pieces .
so when enter QTY in textbox6 then should calculate pieces for each box based on textbox1,textbox2
in this case textbox6 contains 22 pieces and compare with pieces in textbox2 and in this case every 10 pieces in textbox2 will be for each box in textbox1 . so in textbox1 every box contains 10 pieces .
in textbox6 will contain 2 boxes and 2 pieces ( 10+10= 20 for two boxes , 2 pieces will be less than 10 pieces for each box so can't
show as boxes.
here is example to show result in label6 after fill textbox6
should match textbox6 with textbox3 if the QTY in textbox6 bigger than textbox3 and show plus QTY
this is less than one box contains (10 pieces) so will show 3 pieces
I hope theses pictures are clear.
thanks.