DSum Function (Public Function)

[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 (Term) 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]

Was nothing here of assistance?

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

 

[Gasman]

Why are you crossposting?

 

[arnelgp]

post a sample db for us to see.

 

[pbaldy]

Sure, but on the original thread, not here.

 

[arnelgp]

that Thread was "Solved"?
so creating New thread is not a problem.