Searching field for Text and Numbers

  • Thread starter Thread starter Gus
  • Start date Start date
G

Gus

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 said:
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] & '*'
?
 
Back
Top