Search results

I have a database which worked perfectly fine until I took maternity leave and my replacement started deleting things they didn't know about and ended up breaking some of my reports. I have now managed to get everything working properly again, but I am due to go off on mat leave again in the...

I have a report that pulls off Student Attendance records for each group of students (i.e. 60) and has a page break between each student. I have added a parameter to the query behind the report to filter by Subject, so that the user can get a report of students who attended their class...

Hi all, I've started getting an overflow error on the following: SELECT qrySessionsAttended.StudentID, qrySessionsAttended.TotalSessions, qrySessionsAttended.SessionsAttended, [SessionsAttended]/[TotalSessions] AS AttendancePercentage FROM qrySessionsAttended; I assume the error is being...

Hi guys, I have a crude database with poor table structure for what I need and I'm not sure what the best way forward would be. I have attached an image of my tables' relationships to show the current structure. My problem is that for the tblAttendance > AttendanceDate these are different for...

Hi all, I have a table of Students and a table of attendance. For tblAttendance I have the following fields: Student ID (Linked to tblStudents) Attendance Date Attendance Code (Session 1) Attendance Code (Session 2) Attendance Code (Session 3) Attendance Code (Session 4) For each session...