# character as text

K

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.
 
F

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.
Click to expand...

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

Like "[#]*"
 
K

Kevin

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

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

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

Like "[#]*"
Click to expand...
 
Top