use a user-entered parameter value to search within a record

[bear]

I've made the following expression as criteria for a query:

=[Enter Location to search for:] Or LCase([Enter Location to search for:])

But I would like to be able to allow the user to enter a parameter value, which doesnt have to be exact - in other words is there a function that allows you to take a string and search for the presence of that string within a record?

Thanks!

 

[SydneyGeek]

Re: use a user-entered parameter value to search within a re

In the Criteria, you could try:
LIKE "*" & [Enter the name...] & "*"

Adjust the text in the parameter brackets to suit.

Denis

 

[bear]

Re: use a user-entered parameter value to search within a re

Thanks, I'll have a go and see what happens!
Andrew