Recent content by sherikream

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...

Where in my SQL should I add your coding? SELECT Courses.ID, Count(Courses.CourseID) AS Passed FROM Courses WHERE (((Courses.Grade) Is Not Null) AND ((Courses.GradePoint)>0)) OR (((Courses.GradePoint)=-1)) GROUP BY Courses.ID HAVING (((Count(Courses.CourseID))>=10 Or...

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...

I think we're getting close to what I need!! So excited!! It seems like the (Student_10) is counting F (failing grade). "WU" is also a failing equivalent grade that shouldn't be counted. So there should be a total of 10 courses with a passing grade or credit earned (-1). If it makes it any...

Attached is a zip of my sample tables and data. One more thing I need to add while looking through the data is when a course does not have a grade, it's "in progress" and should not be included in the 10 course count and also not calculated in GPA. Here's the list of courses the 10 courses...

Yes, definitely, i'm going to post some fictitious sample data very shortly.

I'll try out your suggestion. But the complicated thing is that the CourseGrade can be CR/P/S which means a student will get credit but have no grade points and these credit only courses will not be calculated GPA calculation. What would a CR/P/S be decoded to in the GradePoints (integer) column...

Correction, Credits for Course5 F should be 3 credits and not 0 credits, A GPA (grade point average) is a calculated average of the letter grades you earn in school following a 0 to 4.0. F is a failing grade. There are also failing equivalent grades WU, FIN, for excessive...

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...

yes, I plan to try breaking the relationship first. Where do I enter the function? The function will take the current field's data and duplicate it into the new field with my desired length and keeping the end values?

The ID will be changed to non-primary key. There is a possibility that another student does have the same last 4 digits.

I've uploaded a photo of an example. The studentID is where want to decrease the field size and only keep the last 4 digits. Within the student ID are all the appeals that the student has submitted.

The data is numeric but set as text data type. Would that need the Mod or Mid function? Within each record are more records. For example The field is customer ID, and when expanded, there are customer order #'s. Where do I enter the function? So this function will take the old current field's...

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