MS Access Query:- Custom Function Call with Array as parameter
Budget: ₹600 – ₹1,500 INR
MS Access Query and VBA Custom Function Call with Array as parameter
Remark:- The query should display first three rank holders as 1, 2 , 3 and other records should have blank in the Rank column.
Name Total Rank: Rank(Total, SELECT TOTAL FROM QUERY1)
ali 435 2
john 490 1
sameer 412 3
Enaya 312 " "
In the custom VBA function; Rank(Total, SELECT TOTAL FROM QUERY1), Total is the total marks obtained by the students one for each student and 2nd parameter is Array)
Remark:- The query should display first three rank holders as 1, 2 , 3 and other records should have blank in the Rank column.
Name Total Rank: Rank(Total, SELECT TOTAL FROM QUERY1)
ali 435 2
john 490 1
sameer 412 3
Enaya 312 " "
In the custom VBA function; Rank(Total, SELECT TOTAL FROM QUERY1), Total is the total marks obtained by the students one for each student and 2nd parameter is Array)