"Contians" criteria

[Haz]

can anyone help please, I haven't search this forum for function or anything relatated to contain criteria...

I want to have criteria search for parts contains specific characters. For example in a query, i have part like QS7000A and another part QS6000A. I want to have creteria to return parts that contians 6000 or 7000.

As always, thanks for the help

 

[wware]

Try using "Like" The asterisk ("*") is the wild card.

Like "QS*"

or

Like "QS*A"

 

[Haz]

Try using "Like" The asterisk ("*") is the wild card.

Like "QS*"

or

Like "QS*A"

using what you said is not bringing anything. I just want to select parts contains the middle part which 6000 or 7000.

 

[Haz]

i got it working with the wild card

Like "*" & [7000] & "*"

but, how can I have the result displayed without entering a parameter.

 

[wware]

It's asking you for a parameter because you have brackets around the 7000.

Instead of this:

Like "*" & [7000] & "*"

Use this:

Like "*7000*"

 

[Haz]

It's asking you for a parameter because you have brackets around the 7000.

Instead of this:

Like "*" & [7000] & "*"

Use this:

Like "*7000*"

work great, thanks wware