Code to find an input string in any part of a field

C

Colin Hayes

Hi

I need a little help with a command for my query.

At present I'm using this to find an *exact* match in the whole field
I'm searching

Like [Filter By Which Number?]

This one gives me a match for a search *at the start* of the field I'm
searching

Like [Filter By Which Number?] & "*"


What I need is a command which will give me a match if the search string
appears *in any part* of the search field.


Can anyone help? Any assistance gratefully received.





Best Wishes


Colin
 
C

Colin Hayes

KARL said:
Try this --
Like "*" & [Filter By Which Number?] & "*"
Click to expand...

Hi Karl

Yes - that's got it! Hooray!

Thanks Karl.



Best Wishes


Colin




Colin Hayes said:
Hi

I need a little help with a command for my query.

At present I'm using this to find an *exact* match in the whole field
I'm searching

Like [Filter By Which Number?]

This one gives me a match for a search *at the start* of the field I'm
searching

Like [Filter By Which Number?] & "*"


What I need is a command which will give me a match if the search string
appears *in any part* of the search field.


Can anyone help? Any assistance gratefully received.





Best Wishes


Colin
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the results of a filter by selection in mailmerge 5
Part of a Field in Query 4
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Multiple Search Command criteria in a form 2
VBA: How can I use a string variable as autofilter criteria? 4
Create a web site link from a part link and a data field in access 2003 1
Make Searches Match Any Part of Field 2
Comparing part of the field 4

Top