MS Access question

来源: 2003-11-02 15: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--