469,612 Members | 1,647 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,612 developers. It's quick & easy.

League Table Access 2003

Hi All

I was wondering if anyone knew how to or has developed an access database that could record exam scores and then copy information onto another form as a league table, showing the highest results

Any help would be greatly appriciated

Many Thanks

Stephen
May 24 '07 #1
3 1754
nico5038
3,080 Expert 2GB
Hi Stephen,

It's a very general question you've posted. I've created many databases, even a questionair, but it's always different depending on the requirements.

As I read your requirement, you need a table for the scores and a query to show the top scorers. When you supply some more information we could help you with the design.

Nic;o)
Jun 2 '07 #2
Hi Nic

Thankyou for your reply, what i would like to do is

There is a list of people and these people do exams, i would like to record each result for each exam taken by a person and for each exam
display the scores in the highest order.

Hopefully it is ok to understand, its quite difficult for me to put in words

Many Thanks

Stephen
Jun 4 '07 #3
nico5038
3,080 Expert 2GB
OK, then I guess you have a table like:
tblStudentExam
StudentID
ExamID
Score
(optionaly a date the exam was taken could be added, etc.)

This table is effectively a relation between a table tblStudent and a table tblExam.

For reporting the Max Sore(s) you can now use a "Group By" query like:
Expand|Select|Wrap|Line Numbers
  1. select ExamID, Max(Score) as MaxOfScore from tblDtudentExam 
  2. Group By ExamID
  3.  
You can construct this query using the graphical query editor. Just select the table, the fields ExamID and Score and press the "E" looking GroupBy button.
The press the datasheet button to see the result.

Nic;o)
Jun 4 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Mahesh Hardikar | last post: by
2 posts views Thread by Richard Williamson | last post: by
3 posts views Thread by Ram | last post: by
3 posts views Thread by kylei | last post: by
6 posts views Thread by mtgriffiths86 | last post: by
2 posts views Thread by minus | last post: by
4 posts views Thread by minus | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.