using keyword as SQL query value

[RickBeddoe]

I query a field with the value "current". However "Current" is a keyword and
Access gives an error.

example:

....

WHERE [data]![status] = "current"

I remember there was a prefix or some other character I could put in front
of this in order for it to work, but I don't remember what it was.

Thanks,

Rick

 

[Jerry Whittle]

That should not give you an error due to it being a keyword. What precisely
is the error number and message. Also please post the entire SQL statment.

Actually according to MS, current isn't listed as one of the reserved words.
I'm assuming by keyword and reserved word, that we are talking about the same
thing.

http://support.microsoft.com/kb/286335/

 

[RickBeddoe]

I query a field with the value "current". However "Current" is a keyword and
Access gives an error.

example:

...

WHERE [data]![status] = "current"

I remember there was a prefix or some other character I could put in front
of this in order for it to work, but I don't remember what it was.

Thanks,

Rick

 

[Guest]

haii....

would like to invite everyone to another affiliate program from Global
Domain International Inc.

click here http://www.baharintahir.ws

Thank you

Baharin

 

[Guest]

Haii,

Pls do join us in Affiliate Program from Global Domain International Inc.

http://www.baharintahir.ws

Thank You

Baharin Tahir

 

[Guest]

salut a tous,un peut timide mais bon

"RickBeddoe" <[email protected]> a écrit dans le message
de groupe de discussion :
(e-mail address removed)...