Solved

Rankers list ??

Posted on 2002-03-21
4
123 Views
Last Modified: 2010-05-02
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.


0
Comment
Question by:mrajanikrishna
4 Comments
 
LVL 14

Expert Comment

by:puranik_p
ID: 6888302
for just 30 points?
0
 
LVL 69

Accepted Solution

by:
Éric Moreau earned 30 total points
ID: 6888526
0
 
LVL 16

Expert Comment

by:twalgrave
ID: 7753519
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.
0
 

Expert Comment

by:SpideyMod
ID: 7809876
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now