PDA

View Full Version : Solved: VBA SQL statement (xl '97)



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,

mdmackillop
07-16-2009, 12:34 AM
No expert in SQL, but I guess you need
SELECT * FROM [Dealer List] WHERE [Dealer List].[Scheme] LIKE 'Magsys' OR [Dealer List].[Scheme] LIKE 'Img Systems';

phendrena
07-16-2009, 12:42 AM
Thank you for the reply and the solution.
That does indeed work.

:beerchug: