here is the solution

来源: 于 2003-11-02 22:22:00 [旧帖] [给我悄悄话] 本文已被阅读：次

......
where FullName like '*' & [Input Here:] & '*'
......


then, your users only need to enter John,
records with all FullName containing 'John' return

whatever



--文学城www.wenxuecity.com--