Hi Everyone,
I have a student info, grades and attendance DB that many of you on this forum have helped design. I have not been able to solve my current challenge on my own and need help, please.
From a table of course data that includes a row for each course a student is enrolled including a field for each week of classes (attendance), I would like to FIRST calculate a monthly average for each course for the 4 weeks of attendance data entered for that month (entered as an integer). That would mean a single "cell" for each month (jan-apr) for each course.
I have tried some easy functions written into queries but I often get errors.
Ideally I would like to place a button on the student data form that will open and run the query for the current student and diplay as a chart or pivot table.
I tried using several approaches: crosstab querry, pivot table, query based on another query, etc.
I welcome and appreciate your help
Take care,
Daryl