Formatting text

W

Wulfegang

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
 
W

Wulfegang

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

KARL DEWEY

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

Wulfegang said:
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.

KARL DEWEY said:
Wildcards work for text but you need to use < or > or Between for numbers.
Click to expand...
Click to expand...
 
Top