how do i use wildcards for retrieval of data?

T

tannerps402

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
[email protected]
 
A

Amy Blankenship

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
[email protected]
Click to expand...

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


HTH;

Amy
 
J

John W. Vinson

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 [email protected]
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]
 
Top