vsriharsha
Mar 16th, 2004, 08:19 PM
Hi Everyone,
Im also facing a problem, Im sure most of the amatures are facing with Data Reports.
I have a
Table T1 with RollNumber,TestDate and Marks Obtained.
Table T2 with RollNumber and Name.
Table T3 with TestNumber, TestDate and TotalMarks.
Now I want to retrieve the following and display as a report in DataReports of VB.
"All the names, TestNumber, TestDate, TotalMarks and Marks obtained of the STudents who have taken a Test on a particular date (eg: 03/15/2004)"
Test Number Test Date TotalMarks Name MarksSecured
1 03/15/2004 150 Mr. A 80
Mr. B 75
Mr. C 125
Mr. D 120
Now the problem is: If i Use a sql query to create a new table with the above fields, Im getting the first 3 cols repeated and as a result, the same is reflected in the Report which I dont want.
PLEASE ADVICE SOON.
Warm Regards,
Sriharsha.[CODE]
Im also facing a problem, Im sure most of the amatures are facing with Data Reports.
I have a
Table T1 with RollNumber,TestDate and Marks Obtained.
Table T2 with RollNumber and Name.
Table T3 with TestNumber, TestDate and TotalMarks.
Now I want to retrieve the following and display as a report in DataReports of VB.
"All the names, TestNumber, TestDate, TotalMarks and Marks obtained of the STudents who have taken a Test on a particular date (eg: 03/15/2004)"
Test Number Test Date TotalMarks Name MarksSecured
1 03/15/2004 150 Mr. A 80
Mr. B 75
Mr. C 125
Mr. D 120
Now the problem is: If i Use a sql query to create a new table with the above fields, Im getting the first 3 cols repeated and as a result, the same is reflected in the Report which I dont want.
PLEASE ADVICE SOON.
Warm Regards,
Sriharsha.[CODE]