Duplicate RANK() in Access Forms, how??..

  • Thread starter Thread starter howren
  • Start date Start date
H

howren

I want to create an interactive access form.
As marks are entered the positions are shown
automatically. It's very hard to create that
in Access but very easy in Excel using the function
RANK(). The problem is I need to do it in Access but
after 2 weeks I still don't know how to achieve it.

Please help me.

This is what I am trying to do in MS Access:

Name Marks Pos
----------------
Jane 50 2
Aby 61 1
Chang 44 3

As the marks are entered or changed the POS updates
itself automatically. Any idea how? Take note that I
want to do it in an Access form. There must not be any
sorting to the names, the list is as it is in the table.

Send solution to (e-mail address removed)
THANKS
 
Hi,


Something like:



SELECT Name,
Marks,
DCount("*", "TableName", "Marks>=" & Marks) As Pos

FROM TableName





Hoping it may help,
Vanderghast, Access MVP
 
Back
Top