Dear all
I have a sales report, recorded sales of the month for a customer
I have a queries to filtered the date range
But each customer may have different purchase items.
How can i list only the field that has record?
Client | Item 1 | Item 2 | Item 3
Eric | 1 | 0 | 3
Bertha | 0 | 2 |1
Paul | 2 |0 |0
can anyone help me out, as in actual list there are around 48 items
Eric