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

    access calculated query

    i have a students database which has names, english, maths, physics and biology
    in english i have combo boxes- A,1,2,3,4 In Maths combo box - A,1,2,3,4 and in physics combo box - A,1,2,3,4 and biology combo box - A,1,2,3,4
    in this case A-Absent
    question- i want access query to sum up the numbers in this fields- english, maths, physics and biology and leave A- meaning the student is absent and also to rank from the highest(student with highest totals up to lowest).
    please help me

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Sum the field by studentID, excluding the A,and sort on the sum.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    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
    erickemboi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    73
    I am still new in ms access. kindly assist me in showing me how. i will really appreciate

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Quote Originally Posted by erickemboi View Post
    I am still new in ms access. kindly assist me in showing me how. i will really appreciate
    So you ignored what was offered in your first thread.?

    If you insist of having your structure, then it should just be Maths + English + Physics etc
    You would need criteria of <> "A" for each of the fields.
    Order by the field that holds the sum of all the fields.

    FWIW, you are making this much harder than it needs to be because of your structure. Also it would have been better to have continued in your other thread, rather than just start a new one?
    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

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

Similar Threads

  1. Replies: 3
    Last Post: 08-30-2020, 10:56 AM
  2. Link Access Query with Calculated Fields to Excel
    By PicoTTS in forum Import/Export Data
    Replies: 1
    Last Post: 04-07-2016, 05:45 PM
  3. Replies: 2
    Last Post: 12-30-2014, 01:32 PM
  4. Back in ACCESS 2007 Calculated field in query
    By djcmalvern in forum Queries
    Replies: 5
    Last Post: 04-30-2013, 09:28 AM
  5. Replies: 3
    Last Post: 04-18-2012, 07:10 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