Hello-
I have a table that includes student grades. Every line of the table includes the students name, a course ID, and grade. There is a row in the table for each course the student is taking so each student can have up to 10 lines in the table. I need to somehow write a query that will merge each student's data into one line--basically group by the student name and then show all of the courses they are taking appear to the right on the same line. Does anyone know how I can write a query to do this?
I am using Access 2007.
Thank you!!
Meg