phendrena
07-16-2009, 12:12 AM
Hi there,
I was wondering if someone would be able to point out my error in the following :-
sSQL = "SELECT * FROM [Dealer List] " & _
"WHERE [Dealer List].[Scheme] LIKE '" & "Magsys" & "' " & _
"OR LIKE '" & "Img Systems" & "';"
I get the following error :
Syntax error (missing operator) in query expression '[Dealer List].[Scheme] LIKE 'Magsys' OR LIKE 'Img Systems''.
Thanks,
I was wondering if someone would be able to point out my error in the following :-
sSQL = "SELECT * FROM [Dealer List] " & _
"WHERE [Dealer List].[Scheme] LIKE '" & "Magsys" & "' " & _
"OR LIKE '" & "Img Systems" & "';"
I get the following error :
Syntax error (missing operator) in query expression '[Dealer List].[Scheme] LIKE 'Magsys' OR LIKE 'Img Systems''.
Thanks,