Hi all! What's wrong with this SQL statement using the TOP element?

mySQL = "SELECT TOP 1 Used FROM TestNumbers WHERE Used = No ORDER BY TestNumber"

What I'm trying to do is get the FIRST Testnumber that is NOT being used(ie Used field = No) in the "TestNumbers" Table and then assign the current test that number! Can't we use TOP in Access?

The error I'm getting is "Syntax error in FROM statement". Any help would be appreciated! Thanks!