Search results

  1. S

    Multiple AND criteria for a single field

    Hi Everyone, I'm trying to create a query that returns a count of courses a student has taken, ONLY if they've taken ALL the courses in a specified list, not if they've taken any one of the course in a list. If they're missing even one course from the list, they should not show up when I run...
  2. S

    Count single record if duplicate exists

    I want to do a count of total courses a student has passed, not including a duplicated course. Students are required to pass 5 courses. But may have taken a course more than once to earn a higher grade even if already passed. Is there any "Count" expression or another expression to count total...
  3. S

    Counting courses and calculating GPA

    I need to do the following in MS Access. Any help would be greatly appreciated. Situation: A student is required to have earned credit for 10 specfific courses and there is a average GPA requirement for 8 of the 10 courses. Fs or failing equivalent grades are to be calculated in the GPA...
  4. S

    decrease field size but keep the end values

    Hi, I have this database where I want to change the field size from 9 to 4 but I want to keep the last 4 digits not the first 4 digits. Is there a way to make that change? - Thanks all in advance
Back
Top Bottom