Creating 3 dimensional table

[vikasvvs]

Dear All,

I am trying to create a table for my project.

it has the monthly marks of the 150 students in 10 subjects and for 12 months


someone please help me to create this table


thanks in advance

Pintu s

 

[John Big Booty]

Welcome to the forum.

To do this with a normalised table structure you will need at least three tables, something along the lines of;

TBL_StudentDtl
StudentID (PK)
StudentNumber
StudentGivenName
StudentFamilyName
StudentEnrolDate

TBL_Subjects
SubjectID (PK)
SubjectCode
SubjectDescription
TeacherID (FK)

TBL_Results
ResultID (PK)
SubjectID (FK)
StudentID (FK)
ResultDate
Result

PK = Primary Key
FK = Foreign Key

 

[vikasvvs]

thanks John Big Booty,
I tried the way you explained, but could not make it
Can you help me by creating a simple access file with all the fields,

thanks in advance
pintu

 

[John Big Booty]

OK here's a little kick-starter for you. You will notice that I've stored the students and staff details in the same table rather than separate tables as I had initially suggested, I believe this to be a far better scheme.

 

[vikasvvs]

thanks a lot

 

[vikasvvs]

Dear Mr.John,

The code works fine. thanks a lot

But there are mode fields in the tables which are making it more complicated

I need only 100 student names , their 4 subjects ( say -maths, English,science,computer) - which needs to be stored for 12 months to produce monthly report
no other fields required

How can i convert your file to do my project

Many thanks for your help

pintu

 

[John Big Booty]

All you need to do is produce a query to query between the two date you require for each period.