G
Greg
I'm using classroom template for training database. I've added a column for
date completed in class subform for recording students and when course was
completed.
I've added same column to Students and Classes table.
Under the student subform I can't get the date completed to appear.
Here is the record source for the student subform.
"SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID; "
I've tried everything I can think of to add the date completedto the student
subform, but can't get it to work.
Any help will be much appreciated.
date completed in class subform for recording students and when course was
completed.
I've added same column to Students and Classes table.
Under the student subform I can't get the date completed to appear.
Here is the record source for the student subform.
"SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID; "
I've tried everything I can think of to add the date completedto the student
subform, but can't get it to work.
Any help will be much appreciated.