>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
>