Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access problem

Discussion in 'Information Technology' started by asdd dkek, Jul 28, 2006.

Tags:
  1. asdd dkek

    asdd dkek
    Expand Collapse
    Guest

    I'm playing around with Access.

    I am buildiing a program to calculate grades for my students. I can get it
    to average the final grade, but I can't get it to take the numerical value
    and convert it to an alphabetical grade. Any ideas would be helpful.

    I have, for example, 6 grades. One average is 69. I want that to be a C in
    a query. Ideas??????

    Kirk
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Create a table that contains the minimum score and the matching grade
    letter.

    You can then get the grade by looking up that table.

    Tom Ellison explains the finer points here:
    Lookup in a range of values in a query
    at:
    http://allenbrowne.com/ser-58.html

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "asdd dkek" <newwhite63@bellsouth.net> wrote in message
    news:hjFrg.43511$EX2.30833@bignews5.bellsouth.net...
    > I'm playing around with Access.
    >
    > I am buildiing a program to calculate grades for my students. I can get
    > it to average the final grade, but I can't get it to take the numerical
    > value and convert it to an alphabetical grade. Any ideas would be
    > helpful.
    >
    > I have, for example, 6 grades. One average is 69. I want that to be a C
    > in a query. Ideas??????
    >
    > Kirk
     

Share This Page