First time posting so forgive me if I do not follow proper protocol.
I am attempting to develop a report for my school. We would like to combine some of our students testing results with their current grades in an effort to ensure that we are not missing opportunities for one of our student that may be underperforming.
The reports have the student names and corresponding results in separate columns. I have attempteted to combine the reports using a relationship in access based on the students name. The problem is the resulting query will duplicate test results on each course grade row. I would like for the end report to have all of the students results aligned on the row with the students name. Any assistance would be greatly appreciated.
I am attempting to develop a report for my school. We would like to combine some of our students testing results with their current grades in an effort to ensure that we are not missing opportunities for one of our student that may be underperforming.
The reports have the student names and corresponding results in separate columns. I have attempteted to combine the reports using a relationship in access based on the students name. The problem is the resulting query will duplicate test results on each course grade row. I would like for the end report to have all of the students results aligned on the row with the students name. Any assistance would be greatly appreciated.