Thank you for your input. Sorry for the perceived lack of clarity. Here’s exactly (I hope) what I’m trying to do:
A table in the db (oxadmain) contains hundreds of student attendance records, of which some include the characteristic “Absent”. The task is to show in a WADAResults page all the records that contain “Absent” and all those that don’t, except that the ones that contain the “Absent” characteristic also need to show the percentage of times each student was absent from class, hence the need for a COUNT() function, so that I can calculate the percentage.
% of Absence = Number of Absent records, divided by total number of class days, times 100.
Both the records that have an “Absent” characteristic and those that don’t, need to be shown on the same results page/table, which contains a REPEAT REGION.
In fact, it seems that two COUNT() functions might be needed, one to count the total number of records-per-student entered and another one to count the number of records where the student was “Absent”.
I hope this time the explanation was much clearer.
Thank you for your attention.