SELECT TOP n, where n is a number recive from a combobox

[adita1983]

Hi

I want to select first n recordsets from a table in a new table , where n is a variable recived from a combobox in a form.Here is a part of my code :

Private Sub Submit_Click()
Dim strSQL As String
strSQL = "SELECT TOP cint(Me.cmb_Procent) tblTemp.* from tbl into newtable"
DoCmd.RunSQL strSQL

End Sub

I receive the error : The SELECT statement includes a reserve word or an argument name that is misspelled or missing, or the punctuation is incorrect.

Thanks in advance.

Adrian

 

[lupins46]

You have inconsistent table names and no Order By clause for your Top N. It needs to look something like this:

strSQL = "SELECT TOP " & cint(Me.cmb_Procent) & " tblTemp.* into newtable from tblTemp Order By somefieldhere desc"