Results 1 to 4 of 4
  1. #1
    Join Date
    May 2015
    Posts
    1

    Unanswered: Student Scores display in multiple columns

    Hi everyone could you please help me with this. I'm really new in Access and I'm trying to learn it by my self.
    My first question is, how can I display the scores of a student in horizontal? (Bad english)
    I have two tables, one with students information and another for students' score.
    When I query may table using this

    Code:
    SELECT Student.StudentName, WrittenScores.Score
    FROM Student INNER JOIN WrittenScores ON Student.[ID] = WrittenScores.[StudentID];
    It resulted to this
    Click image for larger version. 

Name:	Capture.PNG 
Views:	5 
Size:	8.6 KB 
ID:	16340

    All I want to do is something like this
    Click image for larger version. 

Name:	Capture.PNG 
Views:	5 
Size:	8.6 KB 
ID:	16340Click image for larger version. 

Name:	1.PNG 
Views:	4 
Size:	3.0 KB 
ID:	16341

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    look at pivot tables/queries
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6
    If you are using 2007 or 2010

    You can go to the Create tab and select (under more forms) create pivot table. There you should be able to move your information around to spread it like you want. 2013 they took it away.

    In 2013 you can build a cross tab query, using the tables. Make sure you make the row heading the students and make the column heading the written scores. That will pull it in like you want. You can also build standard queries to choke down the information for group by's etc. And then reference the query as one of the tables in the cross tab. It works perfect.


    https://www.youtube.com/watch?v=DQJ0Y84UoY0
    Last edited by VLOOKUP; 05-10-15 at 22:06.

  4. #4
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6
    TRANSFORM AVG(GRADE)
    SELECT Student2.Name, Grades2.Grade as Grade
    FROM Student2 INNER JOIN Grades2 ON Student2.[STUDENTID] = Grades2.[StudentID]
    GROUP BY Name
    PIVOT Grade;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •