View Full Version : Applying an * after the query prompt window appears.


dmccs
12-13-2001, 11:04 AM
I have the following in my query criteria field: [What assignee are you searching for?]. I would like to be able to add an asterisk at the beginning by (default) and at the end by (default) of the name that is typed in by the user when the prompt window appears. Any ideas. Thank you in advance for your help.

David R
12-13-2001, 12:37 PM
Use this for criteria:
Like "*" & [Parameter] & "*"

dmccs
12-14-2001, 09:16 AM
So simple...sometimes you forget the basics...thank you thank you thank you...that is a huge help. Your reply is very much appreciated.