Acces Query wont work

[Sl1ver]

Hi i got a query i use my in c# app

SELECT RTR__RTS_ID, RTR__OPTION from qx_RoleRights where RTR_ROL__ID = 1 (one being 'User' in the app)

Problem is it says to value was given in. when i ran the query in acces in sql mode it pops up a box and then i have to enter 1 in there and only then do i get a result

How can i fix this problem?

[ThatThatGuy]

your query being normal should work fine....

[Sl1ver]

problem is, it doesn't want to and i have no idea why not

[Sl1ver]

found the problem, sometimes difficult to notice the small things, should be RTR__ROL_ID and not RTR_ROL__ID

[ThatThatGuy]

Its really not sensible to put 2 underscores 1 is acceptable....

it really creates a mess