If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Searching field for Text and Numbers
Hello,
Thank you for your time. I am trying to create a query that would let a user type any criteria such as a letter(s) or number(s) and have the query produce records that match the criteria. I have tried a few things such as using wildcards but I can't seem to come up with something that will search for any number or letter without having a predefined character or criteria in my query (i.e. 7*. My table is called tbl_Agr_Num(ChkO_ID,User_ID, Date_Checked_Out, Agr_Num) The field which I want to query is Agr_Num I will really appreciate any help that you can provide. |
#2
|
|||
|
|||
Searching field for Text and Numbers
Gus wrote:
Hello, Thank you for your time. I am trying to create a query that would let a user type any criteria such as a letter(s) or number(s) and have the query produce records that match the criteria. I have tried a few things such as using wildcards but I can't seem to come up with something that will search for any number or letter without having a predefined character or criteria in my query (i.e. 7*. My table is called tbl_Agr_Num(ChkO_ID,User_ID, Date_Checked_Out, Agr_Num) The field which I want to query is Agr_Num I will really appreciate any help that you can provide. Have you tried Like [Enter character] & '*' ? -- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" |
Thread Tools | |
Display Modes | |
|
|