Results 1 to 4 of 4
  1. #1
    Cheshire is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2021
    Posts
    2

    Generate the sum of each letter grade a person has from table data

    I inherited a database used for grading. The person who created this set it up where the grader fills out a form, hits submit, and all of the data goes to a table. Among other info, the grader inputs the initials of who they're grading and a final letter grade (A,B,C,D). I'm trying to create a query that will return how many instances of each letter grade a person has.



    An example of what I'm looking for with persons John Smith and Jane Doe:

    JS
    A 15
    B 7
    C 2
    D 1
    JD
    A 17
    B 6
    C 3
    D 0


    Could anyone help me get started with this please? There's over a thousand entries and I'm not about to manually go through the data, but I'm new to Access and am still learning the program.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Take a look at Total and Crosstab queries
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Cheshire is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2021
    Posts
    2
    I was able to figure it out from the Crosstab query. Thank you, Bob!

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by Cheshire View Post
    I was able to figure it out from the Crosstab query. Thank you, Bob!
    You're welcome. Always glad to help if I can
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Assigning a Letter Grade to a number
    By MichaelA in forum Access
    Replies: 23
    Last Post: 09-19-2019, 09:33 PM
  2. Use entry to auto generate a letter
    By templeowls in forum Access
    Replies: 4
    Last Post: 04-10-2019, 08:11 AM
  3. Replies: 2
    Last Post: 11-06-2015, 07:57 AM
  4. Replies: 26
    Last Post: 09-18-2014, 10:18 AM
  5. Replies: 4
    Last Post: 09-18-2012, 05:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums