I have a query that gets the below details:
Brand Model Status HITACHI ZX100 Sold HITACHI ZX100 SOLD HITACHI ZX100 Stock HITACHI ZX100 SOLD
Each line corresponds to a different serial number which i have not included on the report.
On the report, I have grouped the Brand, then model as shown:
BRAND MODEL COUNT HITACHI ZX100 1 ZX200 0 ZX300 0
As you noticed, count was not in the query, what I did was insert a TEXT box and placed the following:
=count(iif([status]="STOCK",0))
It worked fine as shown on table 2, however, i do not want for the "0" to appear on the report.
How can I suppress the 0.