Hi. I work with kbSQL and I'm having a problem with using count()...
I have to run totals for each type of exam, then the totals of all exams for a given time period that meet some other criteria also... I'm using the count() statement to do this, but when I get to the end and I try to use the count() to give the total of all exams, it just repeats the value of the last row... is there any way I can make the scope for the count() statement global when I do it in my final event?
I have to run totals for each type of exam, then the totals of all exams for a given time period that meet some other criteria also... I'm using the count() statement to do this, but when I get to the end and I try to use the count() to give the total of all exams, it just repeats the value of the last row... is there any way I can make the scope for the count() statement global when I do it in my final event?