S
Serendipity
Using Access 2003. Trying to make a grading report that groups on fldyear,
fldquarter, fldSubject, fldLN/FN (trimmed field) and fldGradeWeight then I
want to set up my report with column one listing each individual assignment
with the second column showing the grade for each assignment. fldGradeWeight
will have a group footer which shows the average for all grades falling in
this weight category (this come from qryAvgGrades). In the page footer, I
want the final grade which comes from qrSumOfAvgGrades.
I am messing up with the query that I am trying to make to base this report
on. All is well when I make a query from qryAvgGrades, qrySumOfAvgGrades, and
tblInfo (this table contains the student ID, names, addresses, etc.) But when
I try to add tblMainTable which is where all the individual assignments and
grades are, the query returns more than one row for a single record, e.g.,
Quiz 2 more than one time when there was only one Quiz 2 in the tblMainTable.
Same with all the assignments. Thanks in advance for your help.
fldquarter, fldSubject, fldLN/FN (trimmed field) and fldGradeWeight then I
want to set up my report with column one listing each individual assignment
with the second column showing the grade for each assignment. fldGradeWeight
will have a group footer which shows the average for all grades falling in
this weight category (this come from qryAvgGrades). In the page footer, I
want the final grade which comes from qrSumOfAvgGrades.
I am messing up with the query that I am trying to make to base this report
on. All is well when I make a query from qryAvgGrades, qrySumOfAvgGrades, and
tblInfo (this table contains the student ID, names, addresses, etc.) But when
I try to add tblMainTable which is where all the individual assignments and
grades are, the query returns more than one row for a single record, e.g.,
Quiz 2 more than one time when there was only one Quiz 2 in the tblMainTable.
Same with all the assignments. Thanks in advance for your help.