A
Arni Laugdal
Sandra,
You can solve the problem using a query.
In follwoing case have I a table named tblTheClass with
two colums Student and Grade.
Then did I create a new public Function:
Public Function LaugdalRank(TheNumber) As Long
LaugdalRank = DCount("Grade", "tblTheClass", "Grade
And used it in the query as following:
SELECT Student, Grade, LaugdalRank([Grade]) AS TheRank
FROM tblTheClass;
This is not the fastest way in the world but it works.
Arni Laugdal,
Office 2000 Master Instructor
www.til.is/msaccess
You can solve the problem using a query.
In follwoing case have I a table named tblTheClass with
two colums Student and Grade.
Then did I create a new public Function:
Public Function LaugdalRank(TheNumber) As Long
LaugdalRank = DCount("Grade", "tblTheClass", "Grade
End Function
And used it in the query as following:
SELECT Student, Grade, LaugdalRank([Grade]) AS TheRank
FROM tblTheClass;
This is not the fastest way in the world but it works.
Arni Laugdal,
Office 2000 Master Instructor
www.til.is/msaccess