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