I have a problem with my SQL, all the other statements i have written work so I can't understand why this one isn't!!
the sql is...
sql = "Select * From Skills Where StampNo = " & Stamno & " Cell = " & cell & " And Op-Number = '" & op & "' "
i get this error...
Syntax error (missing operator) in query expression 'StampNo = Test25 Cell = E&M And Op-Number = '80''.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression 'StampNo = Test25 Cell = E&M And Op-Number = '80''.
I can't see what i have got wrong!!
if anyone an see what I have done wrong it would be much appreciated!