访问表/查询/报告中的排名 [英] Ranking in Access Table/Query/Report

问题描述

您好我已经创建了一个包含三个字段的tablein acess 07; admno，name和Mark / 100。我的问题是我需要根据标记得到这个学生的位置字段，即标记最高的标记为位置1，标记最少的标记为最后标记。我希望对那些与商标挂钩的人进行排名。请帮助

例子。表名是学生标记

Admno姓名标记

1200简56

解决方案

你可以使用一个子查询，用于计算有多少标记比学生更大以获得排名。

确实。总是在序号（等级）确定的值中添加一个。

谢谢但是程序是什么，比如在创建查询后我做了什么或者输入了哪些代码？

Hi I have created a tablein acess 07 with three fields; admno, name, and Mark/100. My problem is that i need to have a field with position of this students based on the marks i.e the one with highest mark be position 1 and the one with least marks to be the last. i hope to rank those which tie in marks as well. Kindly help
example. Table Name is "Students Marks"
Admno Name marks
1200 Jane 56

解决方案

You can use a subquery to count how many have marks larger than the student to get their rank.

Indeed. Always add one to the value ascertained of course for the ordinal number (rank).

thanks but what are the procedures, say after creating the query what do i do or which codes do i enter?

这篇关于访问表/查询/报告中的排名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！