mrajanikrishna
asked on
Rankers list ??
Hi Friends,
I am developing an application for a school. VB as frontend and Access Backend.
I am using Datareports. Here i have a problem with one report. I want to generate Toppers list in a class and Rankers list
My Table is
Marks:
studno Text
Classcode Text
Subjcode Text
Marks Number
Exam_Date date/Time
I want a report ....
StudNO Sum(marks) Exam_date Rank
1001 420 ... 1
1020 410 ... 2
1011 390 ... 3
and another Report
Toppers List in a class
Pls give me the query
Thanx in advance.
I am developing an application for a school. VB as frontend and Access Backend.
I am using Datareports. Here i have a problem with one report. I want to generate Toppers list in a class and Rankers list
My Table is
Marks:
studno Text
Classcode Text
Subjcode Text
Marks Number
Exam_Date date/Time
I want a report ....
StudNO Sum(marks) Exam_date Rank
1001 420 ... 1
1020 410 ... 2
1011 390 ... 3
and another Report
Toppers List in a class
Pls give me the query
Thanx in advance.
puranik_p
for just 30 points?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- points to emoreau
Please leave any comments here within the
next seven days.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- points to emoreau
Please leave any comments here within the
next seven days.
per recommendation
SpideyMod
Community Support Moderator @Experts Exchange
SpideyMod
Community Support Moderator @Experts Exchange