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.

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"