Limit virker ikke

Hejsa

Jeg prøver at indsætte en limit i denne kode, men jeg kan ikke få det til at virke. Er der nogen som kan hjælpe?


strSQL = "SELECT " & strDbTable & "Thread.Thread_ID, " & strDbTable & "Thread.Author_ID, " & strDbTable & "Thread.Message_date, " & strDbTable & "Author.Username "
            strSQL = strSQL & "FROM " & strDbTable & "Author INNER JOIN " & strDbTable & "Thread ON " & strDbTable & "Author.Author_ID = " & strDbTable & "Thread.Author_ID "
            strSQL = strSQL & "WHERE " & strDbTable & "Thread.Topic_ID = " & lngTopicID & " "
            strSQL = strSQL & "ORDER BY " & strDbTable & "Thread.Message_date ASC;"