MS Access question

Lets say I have a field called FullName. In the design view of a query, if I add [Input here:] as the Criteria of the field FullName, then when the query is executed, a window pops up saying [Input here:]. It works OK if the sql query is
…………………..
WHERE FullName = [Input here:];

However what I want is
………………………
WHERE FullName LIKE ‘*[Input here:]*’;
It does not work. Can someone tell me how to make this work using the small popup window? I don’t want the user to handle any SQL, they should just type a name, for example, John, in the popup window and the query pulls out all names containing John.

Thanks so much!




--文學城www.wenxuecity.com--

所有跟帖： 

• 回複：MS Access question -f64- ♀ (447 bytes) () 11/02/2003 postreply 19:48:00

• thanks, but it doesn't work -kf_ying- ♀ (345 bytes) () 11/02/2003 postreply 20:50:00

• here is the solution -what5263- ♀ (188 bytes) () 11/02/2003 postreply 22:22:00

• it works!!! thank you so much! -kf_ying- ♀ (0 bytes) () 11/03/2003 postreply 09:27:00

• no problem -what5263- ♀ (177 bytes) () 11/03/2003 postreply 11:23:00