Query Search (1 Viewer)

[GotKegs]

I have a table that I am trying to create a query to search. It contains part #'s and their locations. I want to be able to search the part # with the full number or a partial number and it return the results to me.

example:

PARTNUMBER LOCATION
L296 4-J4
DS1232 5-C4

And I would like to be able to type "DS12" in the form and it return any component that has "DS12" in the part #. I have it where it will return the results correctly if I enter the complete part number but I need it to search with a partial part # as well.

Any help is appreciated!

Cheers,
Paul

 

[jatfill]

in the query criteria, you currently have (I assume):
---------------------------

(form search)
Forms![formame]![PARTNUMBER]

or

(prompt for value)
[Enter the Part Number]

---------------------------
or something similar. If you want to perform a 'wildcard search', try changing it to the following:
---------------------------

(form search)
Like "*" & Forms![formame]![PARTNUMBER] & "*"


(prompt for value)
Like "*" & [Enter the Part Number] & "*"


---------------------------
This appends the wildcards automatically to each side of your input string so "45" would return any results which included "45" in/around the string, including at the beginning or end.

 

[GotKegs]

Thanx!

Jatfill -

That worked like a charm! A headache relieved w/ no medication!

Cheers!