AnsweredAssumed Answered

Product Quantity's 12/11/2012

Question asked by RobinNeeves_2 on Nov 12, 2012
Latest reply on Nov 12, 2012 by philmodjunk

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

Outcomes