Student Progress Database Application

Hi Scott, I tried my best to understand why the names are repeating (most repeat hundreds of times) but could not figure out the cause. I give below the SQL :

SELECT qryStudentProgress_Crosstab.CenterCode, qryStudentProgress_Crosstab.StudentID, qryStudentProgress_Crosstab.StudentName, qryStudentProgress_Crosstab.English, qryStudentProgress_Crosstab.Hindi, qryStudentProgress_Crosstab.Math, qryStudentProgress_Crosstab.Science, (([English]+[Hindi]+[Math]+[Science])/400)*100 AS Percentage, IIf([Percentage]<33,"Fail",IIf([Percentage]=33,"Just Pass",IIf([Percentage]<60,"Fair",IIf([Percentage]=60,"First",IIf([Percentage]<75,"First",IIf([Percentage]>74,"Distinction")))))) AS Grade, tblCenterDetails.Address, tblStudentProgress.GradeMonth

FROM (qryStudentProgress_Crosstab INNER JOIN tblCenterDetails ON qryStudentProgress_Crosstab.CenterCode = tblCenterDetails.CenterCode) INNER JOIN tblStudentProgress ON tblCenterDetails.CenterCode = tblStudentProgress.CenterCode;

This is the SQL of the main query that supplies the report. I just cannot comprehend what's wrong here.

So you figured out that you can use the WHERE clause of the OpenReport Method to filter the records returned by a report? All you needed was "CenterCode = " & Me.CenterCode in the WHERE clause. Like I said, I could have easily told you that, but you should have been able to figure it out by looking at the various parameters you can supply in the method.

Now for the repeating names. We discussed this previously as well. The first thing you need to do is go back to the query that is the Recordsource of the report. Run that query and see if the records are repeating there. If so, the problem is the SQL statement, not the report. So you need to examine the SQL statement and see why it may be returning multiple rows.. You can post the SQL if you need to. If its not the query (though I would doubt it), then there is something in your report design. A screen shot of the report in Design mode may help us help you.

Okay Scott I finally got the OpenReport working with the help of an MSDN article. Now the report filters exactly based on the combo box selection. Great!

However, I've also noticed that when the report does open, the name of each student instead of appearing once with 4 grade scores, appears multiple times in the report. Now this is something I can't seem to understand and need your help on.

Maneesh,

I'm not going to do all your work for you. This site and sites like it are more for giving you direction than providing specific answers. Of I give you all the answers, you won't learn on your own. You need to understand how Access works and how things are done so you can do things yourself.

I told you the answer is in the OpenReport method. Look it up and study the syntax. The answer is there.

Scott, I;ve already generated the report with the OpenReport method. But the problem I'm facing is the report is not being filtered to the Center Code chosen. I tried to filter the query which is using the Crosstab query as a source, but get an error message.