Greetings once again,
I created a database to record lesson information (see attached sample). When there was only one student per record, everything worked fantastic.
However, management would like to have one record per lesson, which means that up to eight students would need to be accounted for.
Adding additional Student_IDs to the lesson record table and the associated links to the student table was simple.
Inputting lesson information was pretty straightforward.
The problem arises with output.
There is one report to review an individual student's past lessons.
Also, there is a form in which to export the lesson's public comment.
Both use different queries, but with the same name as the form and report.
Both the report and exported Excel file are blank, no data.
Any assistance, as always, is much appreciated.
M. McAllister
P.S. I'm building this in A2010, but saved as A2003 (working environment).
I created a database to record lesson information (see attached sample). When there was only one student per record, everything worked fantastic.
However, management would like to have one record per lesson, which means that up to eight students would need to be accounted for.
Adding additional Student_IDs to the lesson record table and the associated links to the student table was simple.
Inputting lesson information was pretty straightforward.
The problem arises with output.
There is one report to review an individual student's past lessons.
Also, there is a form in which to export the lesson's public comment.
Both use different queries, but with the same name as the form and report.
Both the report and exported Excel file are blank, no data.
Any assistance, as always, is much appreciated.
M. McAllister
P.S. I'm building this in A2010, but saved as A2003 (working environment).