RichFrot
asked on
SQL syntax error 80040e14
Hi,
I am getting the following syntax error (missing operator) on the following sql statement. Any ideas?
SQLQuery = "SELECT tblClients.ClientNumber, tblClients.NachaNameContro lCode, tblClientsStates.StateId, tblClientsStates.State" _
& "FROM tblClients INNER JOIN tblClientsStates ON tblClients.ClientNumber = tblClientsStates.ClientNum ber" _
& "WHERE (((tblClientsStates.State) =NJ ));"
rst.Open SQLQuery, cnn, adOpenKeyset, adLockOptimistic
Thanks,
I am getting the following syntax error (missing operator) on the following sql statement. Any ideas?
SQLQuery = "SELECT tblClients.ClientNumber, tblClients.NachaNameContro
& "FROM tblClients INNER JOIN tblClientsStates ON tblClients.ClientNumber = tblClientsStates.ClientNum
& "WHERE (((tblClientsStates.State)
rst.Open SQLQuery, cnn, adOpenKeyset, adLockOptimistic
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ah.. damn! how can i miss that? ;-)
you're right for above discovery, but the space is still important too, so that the recordset object recognize your sql statement.
cheers
you're right for above discovery, but the space is still important too, so that the recordset object recognize your sql statement.
cheers
ASKER
Like this
& "WHERE (((tblClientsStates.State)