Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Rankers list ??

Posted on 2002-03-21
4
Medium Priority
?
131 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 70

Accepted Solution

by:
Éric Moreau earned 120 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…
Suggested Courses

580 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