# character as text

[Kevin]

I want to create a query to search for all records where a particular field
begins with the # character. My query criteria for this field is <Like "#*">
but this produces nothing. I assume the # is reserved but I can't find what
the MS Access Escape character is. Any suggestions would be greatly
appreciated.
Thank you.

 

[fredg]

I want to create a query to search for all records where a particular field
begins with the # character. My query criteria for this field is <Like "#*">
but this produces nothing. I assume the # is reserved but I can't find what
the MS Access Escape character is. Any suggestions would be greatly
appreciated.
Thank you.

Enclose the # within brackets.
To find "#" at the start of the field:

Like "[#]*"

 

[Kevin]

I knew it would be something simple. Thank you very much.

I want to create a query to search for all records where a particular field
begins with the # character. My query criteria for this field is <Like "#*">
but this produces nothing. I assume the # is reserved but I can't find what
the MS Access Escape character is. Any suggestions would be greatly
appreciated.
Thank you.

Enclose the # within brackets.
To find "#" at the start of the field:

Like "[#]*"