Results 1 to 3 of 3
  1. #1
    kangaroo is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2010
    Posts
    2

    Angry How to convert percentages to letter grades in Access 2007? Need help !!

    I have been trying to convert percentage grade to letter grades without success. I am trying to do this in a query. The grades equaivalents are
    0-44 = F


    45-55 = D
    56-70 = C
    71- 89 = B
    90-100 = A

    Kangaroo

  2. #2
    Datagopherdan is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Dec 2008
    Posts
    220
    You could make a table that would have the grades. You would have 3 fields. One field for the beginning range, one for the ending and one for the letter grade e.g.

    Low End High End Grade
    0 44 F
    45 55 D

    You could then either write a function or perform something like DLookup in your query, using that table where you would get the value of each row,

  3. #3
    kangaroo is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2010
    Posts
    2
    how Do I write the function to convert the Percentage grade to Letter grades? I'm new to databases

    Kangaroo

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

Similar Threads

  1. Convert access 2003 to access 2010
    By Vera in forum Access
    Replies: 3
    Last Post: 07-16-2010, 11:01 AM
  2. Replies: 5
    Last Post: 10-24-2009, 01:16 PM
  3. Graph problems (displaying percentages)
    By bingobong62 in forum Access
    Replies: 0
    Last Post: 09-24-2009, 07:50 AM
  4. Convert query sql server for Access
    By webtony in forum Queries
    Replies: 0
    Last Post: 06-23-2009, 02:46 AM
  5. Replies: 1
    Last Post: 10-23-2006, 03:45 PM

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