0

Hey there,

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.

Thanks

3
Contributors
4
Replies
6
Views
7 Years
Discussion Span
Last Post by JAM1011
0

Try writing it out like this, should work.

Poplist2 = "SELECT Machine_ID, Make, Model, Problem, Rating, MacStatus WHERE Rating =" & NewTime & ";"
0

Try writing it out like this, should work.

Poplist2 = "SELECT Machine_ID, Make, Model, Problem, Rating, MacStatus WHERE Rating =" & NewTime & ";"

Hi
Try this

Poplist2 = "SELECT Machine_ID, Make, Model, Problem, Rating, MacStatus from tablename WHERE Rating =" & NewTime & ";"

Thanks,
Paul dani

0

Also you need to add what table you're getting the data from:

Poplist2 = "SELECT Machine_ID, Make, Model, Problem, Rating, MacStatus FROM table1 WHERE Rating =" & NewTime & ";"
0

Also you need to add what table you're getting the data from:

Poplist2 = "SELECT Machine_ID, Make, Model, Problem, Rating, MacStatus FROM table1 WHERE Rating =" & NewTime & ";"

That did the trick
Thanks VERY much for that.
I think I i must he being on drugs to say I didn't spot that. But all the same I more than likley would have never seen that I forgot to but in the table i was taking the info from.


Thanks again
James

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.