Need help missing Operators...

[edgarbenilde]

why there is missing operator error in this codes "SELECT * RSOQuerryFinal where RsoNo='" & UsePrinRSONO & "'"

by the way this from excel and the like the two sheet in the access then those two sheet Put it in the Query and that querry in where in use here... called" RSOQuerryFinal "

then, here is my codes
why there is missing operator as i said above?

Private Sub GetRecords(ByVal UsePrinRSONO As String)
Try
ds = New DataSet
Dim cmd As New OleDbCommand
cmd.Connection = cn
cmd.CommandType = CommandType.Text
cmd.CommandText = "SELECT * RSOQuerryFinal where RsoNo='" & UsePrinRSONO & "'"
da = New OleDbDataAdapter
da.SelectCommand = cmd
da.Fill(ds, "RSOQuerryFinal")
Catch ex As Exception
MsgBox(ex.ToString)
MsgBox(ex.Message)
End Try
End Sub

[SunshineBH]

Small typo in your SQL syntax

it should read

SELECT * FROM RSOQuerryFinal where RsoNo='" & UsePrinRSONO & "'"

[onlyGirl]

Did that help you out?