4 Replies Latest reply on Sep 24, 2013 9:35 AM by AaronBrimacombe

    How do I omit records that do not have a customer in field?

    AaronBrimacombe

      Title

      How do I omit records that do not have a customer in field?

      Post

           I have a database with a customer field and different transactions. When the transaction is not from a customer the customer field remains blank. This has caused me problems when creating a report as I only want to report those records which contain a customer name in the customer field. 

           The reason this is a problem and I cannot simply hide it with conditional formatting is because when I create the summary fields it includes these records which do not relate to any customer as they are other transactions such as bank charges etc.

            

      Screen_Shot_2013-09-24_at_16.47.42.png