How Can I: Make Query Not Have To Match Exactly

[RichardAnderson]

Hello Guys....

I have a query that has the following criteria for one of the fields...
[Enter A Customer] (Must match exactly)]

This works perfect for listing all records for a customer. My problem in with a similar query. We manufacture light fixtures. The database is question is a production schedule. There is a field for the "Build". Every build is typically different, however, some are just variations of the same product.

There is a field named ITEM. In this field are the builds. They can look like this....
VIS816-AS-DE26Q-41
4810-WH-232-41-EM
SFL-BR-150H
VIS714-BN-DE18Q-41



Notice the 1st and 4th items I listed both start with VIS. This is the code for the VISION light fixture. the 816 and 714 after VIS is the size of it. The rest of the code is color-lamping-kelvin.

What I need is to have a query work just like the one for customers, but not have to match exactly. In other words, when the button to run the query is clicked and the dialogue pops up, it would be nice to only have to type in "vis". And after typing in VIS and clicking OK, both the 1st and 4th records would be displayed.

[June7]

Use LIKE operator with wildcard.

Here is one method: http://www.datapigtechnologies.com/f...tomfilter.html

[RichardAnderson]

Thank You... This worked...

[RichardAnderson]

I can across a problem here.

I have a couple items in my testing DB...

SR11-AS-DE26Q
D1010-AS-SE13Q

SR11 and D1010 are the main model numbers.
AS is a color code and...
DE26Q and SE26Q are lamping codes.

When I click the button and type in SR, SR11, or D1010 then it works perfect and displays only that record. However, if you types in "AS" then the resulting form is blank.

Here is my query criteria...

Like [Enter a Model] & "*"

If anyone knows a way to alter this code please share.

If only you could make the find and replace feature work like a filter.

[June7]

You can have wildcard on both sides:

Like "*" & [Enter a model] & "*"

[RichardAnderson]

Thank you so much....

This worked.