I am a novice in programming. I linked my Access 2003 database to Visual basic 6.0 with ADO Microsoft Jet 4.0 OLEDB Provider, using the connection string. The VB has multiple Forms which are linked to different tables. In the qryEngMarks table, I used the DCount Function which I got from the internet to rank Students marks which was successful. But when I try to bind the textboxes on the VB Form to their respective Fields in the qryEngMarks table, I get the error message Undefined Function ‘DCount’ in expression. The following is the Expression I entered in the Field section of the qryEngMarks table in design view to generate the ranks.
Rank: DCount("*","qryEngMarks ","[EngTotal]>" & [EngTotal])+1
The qryEngMarks table has the following fields: StudentID, FirstName, LastName, EngClassScore, EngExamScore, EngTotal, EngRank. Please help me out. Many Thanks.
Is there an alternative method that can rank marks as below?
T would be most grateful for an alternative method. Thank you.