5 Replies Latest reply on Nov 12, 2012 8:49 AM by philmodjunk

    Product Quantity's 12/11/2012

    RobinNeeves_2

      Title

      Product Quantity's 12/11/2012

      Post

            

           Can you help please,

            

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                          

      Size

                     
                          

      Unit

                     
                          

      Type

                     
                          

      Quantity

                     
                          

      Re-Charge Due

                     
                          

      Additional Re-Charge

                     
                          

      2

                     
                          

      KG

                     
                          

      Co2

                     
                          

      10

                     
                          

      2

                     
                          

                                

                     
                          

      5

                     
                          

      KG

                     
                          

      Co2

                     
                          

      4

                     
                          

      1

                     
                          

                                

                     
                          

      2

                     
                          

      KG

                     
                          

      Dry Powder

                     
                          

      3

                     
                          

      0

                     
                          

                                

                     
                          

      3

                     
                          

      KG

                     
                          

      Dry Powder

                     
                          

      0

                     
                          

      0

                     
                          

                                

                     
                          

      6

                     
                          

      KG

                     
                          

      Dry Powder

                     
                          

      7

                     
                          

      0

                     
                          

                                

                     
                          

      6

                     
                          

      LT

                     
                          

      Foam

                     
                          

      0

                     
                          

      0

                     
                          

                                

                     
                          

      9

                     
                          

      LT

                     
                          

      Foam

                     
                          

      3

                     
                          

      0

                     
                          

                                

                     
                          

      3

                     
                          

      LT

                     
                          

      Hydro Spray

                     
                          

      12

                     
                          

      4

                     
                          

                                

                     
                          

      6

                     
                          

      LT

                     
                          

      Hydro Spray

                     
                          

      5

                     
                          

      2

                     
                          

                                

                     
                          

      9

                     
                          

      LT

                     
                          

      Water

                     
                          

      7

                     
                          

      2

                     
                          

                                

                     
                          

      3

                     
                          

      LT

                     
                          

      Wet Chemical

                     
                          

      0

                     
                          

      0

                     
                          

                                

                     
                          

      Totals

                     
                          

                                

                     
                          

                                

                     
                          

      51

                     
                          

      11

                     
                          

                                

                     

            

            

      The above chart shows what I need to achieve let me explain.

            

      I will have a Job sheet that list product on site (above this chart in the body part of the document) I have listed some of the items that may be on a site to help you understand what I need to achieve, the chart show Size this is the quantity that the product hold it may be in Litres (LT), Kilograms (KG) Centimetre (CM) in some cases there may not be a size required.

            

      As you can see from the chart some of the Quantity’s are 0 if this is the case I do not want these listed on the job sheet and all the rows to move up so there are no spaces.

            

      The information in the chart is inserted from a Product list that I have created that includes Type, Size, Unit and Re-Charge Due fields so if Type is added to a customers site I will enter the Type, Size, Unit and Re-Charge Due, The Re-Charge Due date, the recharge due date will only be listed on the job sheet if it is due when the work is to be carried out, the above chart show that one 5 KG Co2 is due for recharge but No 2 KG Dry Powder are due so if there is a (0) in that column I would like it left empty.

            

      I have also created a Product Type data so each product has its own ID number so I just enter a number that enters all the information So if I enter the type as 6 it will automatically enter DP (for Dry Powder) and KG for unit type then I enter the size and the date the product is due for Re_Charging.

            

      I have managed to create Type and Quantity’s on my job sheet in Trailing Grand Summary but I can’t figure out how to add all the other information or get the items to slide up.

            

      Many thank

      Robin