Hey All
I hadn't originally envisioned adding this to the database so the structure may not be ideal. But to help a woman out at work I am trying to achieve this.
See attached pic
There are three main tables. Students, Courses and tblUnits
The courses name field on the courses form pulls data from the Course Name field in tblAvailableCourses. Depending on the course selected the Unit subform will change. The UnitName field in the Units form pulls data from the Unitname field in the tbllinkunits table.
The tblAvailableCourses and tbllinkunits tables hold all the courses we offer and the associated units belonging to each course. For each course there is a Cost field and a Cost field for each unit.
If a student completes the full courses then the course cost would be billed, however if they only complete certain units then the unit cost would be charged.
I need to do a report which will show the billable items for each student, the issue I am having is I cant see a way to pull this info into a report.
Unitnames can be the same across multiple courses. Some courses don't have any units.
I need a way to get the costing for each course and unit a student has completed. Since unitnames can be the same across courses it needs to check the coursename when pulling the unit cost.
I keep getting duplicated values or the wrong cost associated to a unit when I try it can anyone help me out with a query as the datasource?
Many thanks
I hadn't originally envisioned adding this to the database so the structure may not be ideal. But to help a woman out at work I am trying to achieve this.
See attached pic
There are three main tables. Students, Courses and tblUnits
The courses name field on the courses form pulls data from the Course Name field in tblAvailableCourses. Depending on the course selected the Unit subform will change. The UnitName field in the Units form pulls data from the Unitname field in the tbllinkunits table.
The tblAvailableCourses and tbllinkunits tables hold all the courses we offer and the associated units belonging to each course. For each course there is a Cost field and a Cost field for each unit.
If a student completes the full courses then the course cost would be billed, however if they only complete certain units then the unit cost would be charged.
I need to do a report which will show the billable items for each student, the issue I am having is I cant see a way to pull this info into a report.
Unitnames can be the same across multiple courses. Some courses don't have any units.
I need a way to get the costing for each course and unit a student has completed. Since unitnames can be the same across courses it needs to check the coursename when pulling the unit cost.
I keep getting duplicated values or the wrong cost associated to a unit when I try it can anyone help me out with a query as the datasource?
Many thanks
