I've got a report that shows all the (school)classes that are given in the first collumn, the amount of students that were absent in the second and in the third collumn the group a student is in.
In the last collumn I would like to have an attendance rate.
That must look like this:
=1-([CountOfTraineeAbsent]/X)
where
X = the number of people in a certain group (A or B).
How can I make a reference to a query, that has counted the number of students in group A and B?
In the last collumn I would like to have an attendance rate.
That must look like this:
=1-([CountOfTraineeAbsent]/X)
where
X = the number of people in a certain group (A or B).
How can I make a reference to a query, that has counted the number of students in group A and B?
