Querying a DB by a match on part of field string.

[Woodpecker]

On Access 2000, I want to produce a query by a complete match on one field, but also by a match on part of the text string of another field which is entered in a pop-up, ie.to query the Title field and list all records containing the string 'Ship' . I've tried different expressions but none work. Guidance here would be much appreciated!

 

[Gasman]

Use Like *

 

[MajP]

Like "*" & [Enter Text] & "*"

That matches any word with "Ship" in it


Like "*" & [Enter Text] matches any string starting with Ship
Like [Enter Text] & "*" matches any string ending in Ship

 

[Woodpecker]

Like "*" & [Enter Text] & "*"

That matches any word with "Ship" in it


Like "*" & [Enter Text] matches any string starting with Ship
Like [Enter Text] & "*" matches any string ending in Ship

Thanks MajP, that was just what I needed!