how do i use wildcards for retrieval of data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble in designing a query to prompt user input via wildcards.
How do I go about making this happen. For example: I promt the user by asking
[Input Item number], the user then inputs any item number and the item number
appears in front of him as a record on a form. Help. Please respond to
(e-mail address removed)
 
tannerps402 said:
I am having trouble in designing a query to prompt user input via
wildcards.
How do I go about making this happen. For example: I promt the user by
asking
[Input Item number], the user then inputs any item number and the item
number
appears in front of him as a record on a form. Help. Please respond to
(e-mail address removed)
Click to expand...

SELECT YourField1, YourField2 FROM YourTable WHERE YourField3 = [Input Item
Number]


HTH;

Amy
 
I am having trouble in designing a query to prompt user input via wildcards.
How do I go about making this happen. For example: I promt the user by asking
[Input Item number], the user then inputs any item number and the item number
appears in front of him as a record on a form. Help.
Click to expand...

Your description doesn't involve anything to do with wildcards: the user types
an item number, they get that item number. I'm not sure what behavior you're
seeing and what you expect!

Use a criterion of

LIKE [Input Item Number] & "*"

to let the user type the first few characters of an item number, and see all
of them.
Please respond to (e-mail address removed)
Click to expand...

Ask here... get your answers here. Private EMail support is available to
paying consulting customers; if I'm volunteering my time, I would prefer to
keep it public.

John W. Vinson [MVP]
 
Back
Top