MS Access question kf_ying2003-11-02 23:41:00

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

thanks, but it doesn't work

here is the solution

it works!!! thank you so much!

no problem