Need help with Gradebook database

[rcmcdonald91]

I am designing a database that will do the following:

Table for Students
Table for Teachers Assistants (Used to designate TA Groups)
Table for Assignment Categories
Table for Assignments
Table for Grades

I have attached a data-less version of my project

Basically, I'm trying to figure out how exactly to generate a report that looks like this

[Student ID] [Assignment 1] [Assignment 2] [Assignment 3] [etc...]
1.......................5.....................25.. ............5..........................
etc......



http://dl.dropbox.com/u/19951527/gradebook.accdb

Thanks

[June7]

You want to display records horizontally (left to right). There are several methods to accomplish this. Common topic. Search this forum and Google. Here is one
https://www.accessforums.net/forms/d...lly-20989.html