I am having a little trouble with my select statement. It works grand until I but a where clause in. then I the follow error
Syntax error (missing operator) in query expression 'MacStatus where((Rating =70 ))'.
This is the string I am submitting to the DataBase .
Poplist2 = "Select Machine_ID,Make,Model,Problem,Rating,MacStatus " & "where((Rating =" & NewTime & " ));"
Can someone please help with this is might so small I i cant figure out what is wrong with it.