Delete except one (Access 2000)

Topic

New Reply

I want to delete everything in the tables Students except the records
for the student with ID number = 1.
How can i do it ?
The code i tried and failed was :

Dim SQL As String
DELETE * FROM Students WHERE StudentID t 1 ”
what i mean is that student is not = 1,but i do not know how to express it

Reply | Quote

Replies

Why do you have a “t” in WHERE StudentID t 1 ? Without the “t” it should work OK.

Reply | Quote

Why do you have a “t” in WHERE StudentID t 1 ? Without the “t” it should work OK.

Reply | Quote