using keyword as SQL query value

  • Thread starter Thread starter RickBeddoe
  • Start date Start date
R

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
 
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 said:
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
Click to expand...
 
Back
Top