>>You are addicted. (^.^)
>>
>>Basically I agree with you. But the originator of this thread mixed up records with cursors so I tried to keep it simple.
>>
>>there are numerous ways like
>>

>>	create cursor Rakija;
>>	(	a	c(1), ;
>>		b	c(1),; 
>>		c	c(1) ;
>>	)
>>	insert into Rakija values ('', 'x', 'y')
>>	insert into Rakija values ('', 'x', 'y')
>>	insert into Rakija values ('a', 'x', 'y')
>>	insert into Rakija values ('b', 'x', 'y')
>>	insert into Rakija values ('c', 'x', 'y')

>
>But we may have a request to count each field separately, for which you'd then have to run one select per. Can be done in a single select
>
>

	select sum(iif(empty(a), 1, 0))  as CntA;
>		, sum(iif(empty(b), 1, 0))  as CntB;
>		, sum(iif(empty(c), 1, 0))  as CntC;
>		from Rakija ;
>		into cursor RakijaTmp
>
>               select Rakija
>	
>	&& report cursor = Rakija, use RakijaTmp.CntA, .cntB etc as field in summary
>>

No objection.


More Beer