Search results

Thank you for your reply, Wayne. But, if I read Jon K's code right, the recordset rstList in the sample ' open distinct list of exam date, session and student id as a recordset. SQL = "SELECT [ExamDate], [Session], [StudentID], " & _ " Sum([tblExams].[Duration])+(Count(*)-1)*#0:5# as...

Jon K, I'm new to VBA and eager to learn. Your database runs fine. When I read your code, I find this SQL string. SQL = "SELECT [Exam]" & _ " FROM [tblExams]" & _ " WHERE [StudentID]=" & rstList![StudentID] & " AND" & _ " Format([ExamDate],'yyyymmdd')='" &...