Microsoft Access Query Make table SQL
===

Can someone tell me whats wrong with my where clause in this statement in a Access SQL

        SELECT * INTO [Enrolled Students]
        FROM [Candidate Details];
        Where Student ID  != 'rejected' OR 'pending' OR 'taster';

Or if possible, could it be corrected to where IsNumeric(Student ID)?


I cant seem to figure it out

Thanks Guys!

