I keep track of students who make honor roll each quarter.
I have two tables - One labeled EMF that contains the student's name and ID#, and another named HNR that contains ID#, HR_Grade, and HR_Type. HR_Grade can have the value "QT1GRADE" OR "QT2GRADE" OR "QT3GRADE" - meaning 1st, 2nd or 3rd quarter. HR_Type can have values of "000", "AB" or "A" - meaning "Didn't make honor roll", "Made A's & B's" and "Made all A's"
The SET is based on EMF table with a ONE to MANY link to HNR with the linking field ID#.
I need to know which students made the HONOR ROLL 2 out of 3 quarters. In other words they need to have A or AB on two of the three quarters.
I wrote this query expression, BUT get an error that I have specified an invaled filter order... Can anyone help? Graduation is this week! Thanks - Dave
((Hnr->Hr_grade = "QT1 GRADE") .and.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" ) .AND. (Hnr->Hr_grade = "QT2 GRADE") .AND.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" ))
.OR.
((Hnr->Hr_grade = "QT1 GRADE") .and.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" ) .AND. (Hnr->Hr_grade = "QT3 GRADE").AND.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" ))
.OR.
((Hnr->Hr_grade = "QT2 GRADE" ) .and.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" )
.AND. (Hnr->Hr_grade = "QT3 GRADE" ) .and.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" ))
I have two tables - One labeled EMF that contains the student's name and ID#, and another named HNR that contains ID#, HR_Grade, and HR_Type. HR_Grade can have the value "QT1GRADE" OR "QT2GRADE" OR "QT3GRADE" - meaning 1st, 2nd or 3rd quarter. HR_Type can have values of "000", "AB" or "A" - meaning "Didn't make honor roll", "Made A's & B's" and "Made all A's"
The SET is based on EMF table with a ONE to MANY link to HNR with the linking field ID#.
I need to know which students made the HONOR ROLL 2 out of 3 quarters. In other words they need to have A or AB on two of the three quarters.
I wrote this query expression, BUT get an error that I have specified an invaled filter order... Can anyone help? Graduation is this week! Thanks - Dave
((Hnr->Hr_grade = "QT1 GRADE") .and.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" ) .AND. (Hnr->Hr_grade = "QT2 GRADE") .AND.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" ))
.OR.
((Hnr->Hr_grade = "QT1 GRADE") .and.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" ) .AND. (Hnr->Hr_grade = "QT3 GRADE").AND.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" ))
.OR.
((Hnr->Hr_grade = "QT2 GRADE" ) .and.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" )
.AND. (Hnr->Hr_grade = "QT3 GRADE" ) .and.
(Hnr->Hr_type = "A" .or. Hnr->Hr_type = "AB" ))
Comment