How do I omit records that do not have a customer in field?
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.