AnsweredAssumed Answered

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

Question asked by AaronBrimacombe on Sep 24, 2013
Latest reply on Sep 24, 2013 by 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

Outcomes