Public Dsum Function with Three Criteria

[Musoke Herbert]

Hello Friends, I need your Help
I have a Query named (ALevelreportsQ) , in this Query i Have Points scores by Students Field name (Points)
Each student Has a StudentRegistrationNumber as Shorttext (StudentID) , and this examination are Done per term Field Name (Term) and Each Student Belongs to a Class field name (Class) for a Given year field name (Schoolyear)

I would like to create a Public function Such that the Function can Add the Points scored by a student considering a studentID,Class, Term and Schoolyear

I will be so pleased if i get Helped
Thanks​

 

[pbaldy]

This seems like the same question you've asked twice before. It would be best to follow up on your original thread rather than creating new ones.

Solved - PUBLIC FUNCTION FAILED TO WORK

Hello members am trying to Develop a public function , below but its failling to Work can u please hel Public Function TotalPoints(StudentID As String, Class As String, Term As String, SchoolYear As Integer) As Integer ' Returns the total of points for a student in a given class in a term...

www.access-programmers.co.uk