Hi,
I have written a query to find the number of students we have on our books who are between 15 and 18. The query lists the students and gives the total number in data sheet view.
Now I have written another query which looks at the number of students between 15 and 18 who have completed a course. this also works fine.
What I would like to do now is write another query that expresses the number of completers as a percentage of the number of students. Can anyone tell me how to do this. Do I need to join the two queries. If so, the total doesn't appear in design view so I am not sure how to access this in designing the query.
thanks for your help
Hazell
I have written a query to find the number of students we have on our books who are between 15 and 18. The query lists the students and gives the total number in data sheet view.
Now I have written another query which looks at the number of students between 15 and 18 who have completed a course. this also works fine.
What I would like to do now is write another query that expresses the number of completers as a percentage of the number of students. Can anyone tell me how to do this. Do I need to join the two queries. If so, the total doesn't appear in design view so I am not sure how to access this in designing the query.
thanks for your help
Hazell