I have created a query where Status = 2, count all names as MemberQty - that works just fine - I get an answer of Status 2 and Members 145.
But when I change it to Status = 3, count all names as AssociateQty, it doesn't work because there are no Associates. The answer is null.
Working in query design, I have 2 columns -Status and AssociateQTY: NZ([NCODE],0). I believe this should give me an answer of Status 3 and Associate 0 - but it doesn't.
Any help would be appreciated