1 Reply Latest reply on Aug 11, 2013 7:13 AM by philmodjunk

    Summary of certain filtered records from a table

      Title

      Summary of certain filtered records from a table

      Post

           I have an invoice solution, tables of which include; Invoice Details, Invoice Items and Products.

           Each product record has a nominal ledger code (only three different codes, numerical).

           When an invoice is created, there are normally about three lines that have one code, and two other lines with their unique codes. I need to create a way of totally each coded line items, as opposed to the total of all line items. 

           For example:

                                  Product                             Price               Code

           LIne 1           Paper                                  20                      10000   

           Line 2            Delivery                            5                           11000

           LIne 3            Pen                                    2                           10000

            

           SubTotal: 27

      Total Coded 10000 - 22

           Thank you