Attempting to produce a form that displays Attendance record for a course that is six days long (day1 - day6)
When I hard code the SerialID to 277 I get the desired result
SELECT qryAttendance_Crosstab.StudentCourseID, Course.CourseID, Course.Course, Serial.SerialID, Serial.Serial, Student.StudentID, IIf(IsNull([Student]![ProperFirstName]),StrConv([Student]![FirstNames],3),[Student]![ProperFirstName]) & " " & IIf(IsNull([Student]![ProperLastName]),StrConv([Student]![LastName],3),[Student]![ProperLastName]) AS Name, qryAttendance_Crosstab.[1], qryAttendance_Crosstab.[2], qryAttendance_Crosstab.[3], qryAttendance_Crosstab.[4], qryAttendance_Crosstab.[5], qryAttendance_Crosstab.[6], qryAttendance_Crosstab.[Total Of Hours], StudentCourse.CourseStatus
FROM Student INNER JOIN (Course INNER JOIN ((qryAttendance_Crosstab INNER JOIN StudentCourse ON qryAttendance_Crosstab.StudentCourseID = StudentCourse.StudentCourseID) INNER JOIN Serial ON StudentCourse.SerialID = Serial.SerialID) ON Course.CourseID = StudentCourse.CourseID) ON Student.StudentID = StudentCourse.StudentID
WHERE (((Serial.SerialID)=277) AND ((StudentCourse.CourseStatus)="Registered" Or (StudentCourse.CourseStatus)="In Progress" Or (StudentCourse.CourseStatus)="Completed" Or (StudentCourse.CourseStatus)="Failed Exam" Or (StudentCourse.CourseStatus)="Failed Course"))
ORDER BY Student.LastName, Student.FirstNames;
But when I attempt to bring this value from a drop down menu at the top of the page I get a blank form - (I even added the Parameters section)
PARAMETERS [Forms]![frmAttendance]![cboSerial] Long;
SELECT qryAttendance_Crosstab.StudentCourseID, Course.CourseID, Course.Course, Serial.SerialID, Serial.Serial, Student.StudentID, IIf(IsNull([Student]![ProperFirstName]),StrConv([Student]![FirstNames],3),[Student]![ProperFirstName]) & " " & IIf(IsNull([Student]![ProperLastName]),StrConv([Student]![LastName],3),[Student]![ProperLastName]) AS Name, qryAttendance_Crosstab.[1], qryAttendance_Crosstab.[2], qryAttendance_Crosstab.[3], qryAttendance_Crosstab.[4], qryAttendance_Crosstab.[5], qryAttendance_Crosstab.[6], qryAttendance_Crosstab.[Total Of Hours], StudentCourse.CourseStatus
FROM Student INNER JOIN (Course INNER JOIN ((qryAttendance_Crosstab INNER JOIN StudentCourse ON qryAttendance_Crosstab.StudentCourseID = StudentCourse.StudentCourseID) INNER JOIN Serial ON StudentCourse.SerialID = Serial.SerialID) ON Course.CourseID = StudentCourse.CourseID) ON Student.StudentID = StudentCourse.StudentID
WHERE (((Serial.SerialID)=[Forms]![frmAttendance]![cboSerial]) AND ((StudentCourse.CourseStatus)="Registered" Or (StudentCourse.CourseStatus)="In Progress" Or (StudentCourse.CourseStatus)="Completed" Or (StudentCourse.CourseStatus)="Failed Exam" Or (StudentCourse.CourseStatus)="Failed Course"))
ORDER BY Student.LastName, Student.FirstNames;
Any ideas would be most generously received as I have struggled with this for quite some time now
Rick