How to stop repeat of results in report, despite using Select Distinct...

[smallWorld]

Hi all,

The duplication of results in the Cost Report only happens when in the Course_Details table, in the Course_ID field, there is two StartDate.

Meaning to say, there wouldn't be any problem when generating the cost report when there is only 1 BCF2 in the Course_Details table, with the start date of 24/03/2008. It has 7 related records in Stud_Attend_Courses table. So the cost report will correctly show the 7 records as results.

However, once I added in another BCF2 with the start date of 24/09/2007 in the Course_Details table, the cost report will show the 14 records. There is a duplication.

Attached is my DB. Hope there is a method to solve this problem. Thanks a lot!!!!

 

[smallWorld]

Basically, the deisgn of my DB is very simple.

1) A user must first register a course by clicking on the Course button on the switchboard.
E.g: Word, power point, Access... . Data are saved into Course table.

2) For a Word class, there can be few start dates. Meaning different starting dates for teaching the same course. User will enter in the different start dates by clicking on the Course Details button on the switchboard. Data are saved into Course_Details table.

3) A student will have to be registered by clicking on the Student Profile button on the switchboard. All data are saved in the Student_Profile table.

4) After a student has registered, they can register for courses, by clicking on the Student Course Registration button on the switchboard.

5) User can check how many students attend the course (E.g.: Word) by clicking on the Cost Report button on the switchboard.


Thanks n hope this problem will be soon solved. Thx. Pls help!