QUERY TO MATCH ANY OR ALL CHARACTERS 1

[baybie]

Hello does anyone know of a parameter query which can look for a match to any or all of the characters typed in. at the moment i use the query Like [First few letters of Title] & "*"
This seems to oonly be useful for looking up names etc. Any ideas?

 

[dekcool]

try LEFT([FieldName],[Length]) or try MID() and RIGHT

 

[lhite]

In the query's criteria type:
Like "*" & [FieldValue] & "*"

Thus, if the field is a last name field and the user types in "Smith" it will return Smith, Smith-Jones, Walker-Smith, etc.

-Larry

 

[Smack]

Thanks Larry for the tip, and Baybie for the post. I just so happened to be assigned a task today, looked in the querie folder and had my question answered!
This forum is great!

 

[baybie]

THANKS GUYS!!