convert colums to rows

  • Thread starter Thread starter pack
  • Start date Start date
P

pack

I have a table in which I record student grades. Each record in the table
records the student name, date, assignment, and grade. I have 60 students
each with up to 10 grades per year over a 5 year period. Currently may table
consist of over 1600 records.

I want to create a report where each row is a list of grades for one student.
For example column 1 is the student name
column 2 is the students 1st grade,
column 3 is the students 2nd grade,
column 4 is the students 3rd grade
so on……

The colum heading to just be to group the grades by year.
 
pack,
The problem is really a matter of design. Your grades should be in a
separate table, related to the student via some unique key value, such as
StudentID.
The Student is the ONE, and the multiple grades are the MANY (a main
form based on tblStudents, with a continuous subform based on tblGrades, and
related by StudentID)
Ex.
tblStudents
StudentID StudentName
111 Bob Smith
222 Mary Jones

tblGrades
StudentID GradeYear Grade
111 1 B
222 1 D
111 2 B
111 3 C
222 2 D

On yout form, when you go to Bob Smith's record, the continuous subform
will display only his grades.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top