Results 1 to 4 of 4
  1. #1
    erickemboi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    73

    Access query for adding numbers and leaving a letter

    I am new in access. I am making a student database. I have created a combo boxes for the following subjects
    English
    A


    1
    2
    3
    4
    Mathematics
    A
    1
    2
    3
    4
    Physics
    A
    1
    2
    3
    4
    Biology
    A
    1
    2
    3
    4
    Now
    A- Absent (student missed exams)
    1,2,3,4 are marks for present students
    My question is i want a query to add only numbers and leave A and also to rank students after getting totals for each students. I will appreciate. Please.

  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
    What about some information on your tables and relationships.
    Can you show us the relationship window or post a copy of the db.
    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
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,859
    Really, you should only have a table with those entries and a FK to them in your exam table.
    That will be why Bob is asking for your structure.

    Then it would be easy to ignore where Result = 4 (which would equate to A) 4 would be the ID in the PassLevel table.?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

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

Similar Threads

  1. Replies: 7
    Last Post: 09-10-2019, 01:41 PM
  2. sort field with numbers AND letter
    By dsmithe in forum Queries
    Replies: 12
    Last Post: 09-10-2018, 07:49 PM
  3. Adding a letter after a date
    By Sturgis76 in forum Forms
    Replies: 1
    Last Post: 04-05-2017, 06:19 PM
  4. Numbers to a letter
    By snipe in forum Queries
    Replies: 3
    Last Post: 04-30-2015, 11:06 AM
  5. Replies: 4
    Last Post: 09-18-2012, 05:07 AM

Tags for this Thread

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