# character as text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 "[#]*"
 
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...
 
Back
Top