Parameter query using wildcard characters (1 Viewer)

[brianborn]

I have a field in a table that represents a bin location for inventory items. Within this string of characters are 2 digits that represent a product code. The product code will group similar products like screws, paint, aluminum, etc. I would like to create a parameter query to be able to enter a product code and have it return all items in that group. However, I'm not sure how to accomplish this task.

The data in this field consist of 10 characters with the 3rd and 4th being the product code. I have tried using the following as the criteria, but it does not work.

Like "??" & [Enter Product Code]

I have found a lot of helpful info searching online, but nothing so far that has helped me solve this problem. Hopefully someone here will be able to help.

 

[boblarson]

Create a new field in your query like:

prc: Mid([original field name here],3,2)

Then just use the criteria

[Enter Product Code]


But I would just use a form for input to select the code.

 

[brianborn]

prc: Mid([original field name here],3,2)

Thank you Bob as this is exactly what I needed. I'm learning more every day.