Hi all,
FYI, pretty new to access reports but long time programmer here.
I've developing a system to maintain class grades and records as students complete subjects. I can create a report that shows all the complete coursework and grades, but when the reports are reviewed for completion, I need to list the courses not yet completed as well, such as:
Jim Smith
LEC 101 A
LEC 102 B
LEC 201
LEC 202
Etc. - shows courses with completed grades as well as courses not yet taken yet with grades not there of course.
I don't even want to take a guess on where to start with it as to the simplest method, do, I'll just leave it there. But the data from the instructors is quite extensive and will be imported from a 30 column excel spreadsheet, so it's not a matter of having the courses already in the table and simply entering a grade.
Each record will have the student ID, name, course number, semester, instructor, various grading areas, hours missed, comments, etc etc.
Thanks much!