Need Help 2
I am currently converting an access DB to MS SQL.

I am currently trying to figure out how to code this

I need the count of all rows in colum TERM that is > 1 when its grouped by the COLUM NAME

Anyone got any Ideas,

I do not know the specifics of MS SQL, however a general approach to your problem might be

select column, count(*)
from table
where term > 1
group by student;