Geoff Taylor
Active Member
- Joined
- Dec 11, 2006
- Messages
- 257
Hi,
Apologies if this is newbie level stuff; I'm better with Excel than Access...
I have a table of students. Two of the fields in each student record are the individual courses being studied and an overall program of study.
Each program is made up of courses. Each course can contribute to several programs. (For instance, a course on basic anatomy could form part of a medical program or a sports science program).
I would like a query to generate a number of students for each course within each program. Could someone point me in the right direction?
Apologies if this is newbie level stuff; I'm better with Excel than Access...
I have a table of students. Two of the fields in each student record are the individual courses being studied and an overall program of study.
Each program is made up of courses. Each course can contribute to several programs. (For instance, a course on basic anatomy could form part of a medical program or a sports science program).
I would like a query to generate a number of students for each course within each program. Could someone point me in the right direction?