Can you use wildcards in parameter queries?

[noaccessguru]

Hi guys,
I have a question about parameter queries. I would like to use a parameter query where the user can type in a search string in a parameter query. I know that to make the query ask for the criterion, you enter a question in square brackets in the query design window. E.g. for a database of Materials, you can enter this as a criterion for Raw Material name:

[Enter Material Name] (ie - Sugar) and this will bring back all the records that match exactly to 'Sugar' only

I know you can also put in Like *Sugar* and it will bring up all the Materials that contain the word 'Sugar' in it (ie Sugar Syrup, Brown Sugar etc)

But that is hardcoded into the query - I would like to know how to do that in a parameter query, so that the user can enter a word or part of a word and it will bring back all the records that contain that word or few letters???

So it will prompt them to enter a word or first few letters etc and it will bring back all the records.

ie, enter 'Sug' and it will bring back all the records that contain those letters (Sugar, Sugar Syrup, Brown Sugar etc)


Hopefully that makes sense

Any help appreciated!

Thanks

[alansidman]

Use something like this in your query criteria.

 Like [Enter * for all or first four letters of last name and *]

Or

Like [Enter first four letters of last name] & "*"

Alan

[noaccessguru]

Hi Alan,

Thanks heaps for that! Have used the 2nd option and it works well!

Appreciate your help!

Thanks again

[noaccessguru]

Hi Alan,

If I have text boxes where the user can enter in a word and I want it to bring back ALL the records that CONTAIN that word, how do I set my criteria for this?
I want to hard code this into my query....(so that the user doesn't have to enter in the asterisks themselves in the text box, ie - *sugar*)

below is the criteria I am using, but this only brings back records that START with whatever is entered into the Text box.

Like [Forms]![Frm_MaterialsSearch2].[tbProduct] & "*"


Any help would be great.

Thanks again

[alansidman]

Try this.

Like "*" & [Forms]![Frm_MaterialsSearch2].[tbProduct] & "*"

Alan

[noaccessguru]

Thanks a million Alan!

That worked!

Appreciate it...