Formatting text

[Guest]

I have just recently started to get in depth with Access 2003 (as in, last
friday!!!) and I have set up a form that runs a query and will give me the
correct data, even with wildcards. My problem is one of the search criteria I
have to use is the # and for some reason I cannot get it to work with
wildcards. I am assuming this is because it is reading it as searching for
0-9.

Could any help me figure out the best way to make this work. Removing the #
from the table is not an option as it is going to be a live link to a SQL
database and will be pulling the # when it refreshes. Hope I didn't sound too
stupid and would appreciate any help. TYIA.

Shane

 

[Guest]

Wildcards work for text but you need to use < or > or Between for numbers.

 

[Guest]

Ok but do you know if there is any way to make it work with the # symbol
without having to put [#] in the text box when I do the search? Sorry if I
made it seem like I was being lazy and using # for the word number heh.
Should have been more clear.

 

[Guest]

Try this as your criteria --
Like "*[#]*"

Ok but do you know if there is any way to make it work with the # symbol
without having to put [#] in the text box when I do the search? Sorry if I
made it seem like I was being lazy and using # for the word number heh.
Should have been more clear.

Wildcards work for text but you need to use < or > or Between for numbers.