Folks, Thank you SO much. Both replies were extremely helpful and got me where I needed to be. I appreciate it very much.

Harry C

Ok, I edited it to this...

SELECT ID_NUM, TRANSACTION_STS, REPEAT_FLAG,

LEFT(CRS_CDE, 8) AS ADV, COUNT(*) As NumberOfTimesTaken

FROM STUDENT_CRS_HIST

WHERE (ID_NUM = 126366)

AND (NOT (REPEAT_FLAG IN ('*', 'R')))

AND...