回复：MS Access question

1. do not assume your users are all idiot. they can learn to know * stands for everything.
so just use WHERE FullName = [Input here:];
tell your users to put John* in the box.

if you want the second approach, you need "dynamic building of sql string", which is not available in access, only in SQL Server.

2. IIRC, Access does not support *John*. It only allows John* (or maybe *John ?). Only SQL server support the form %John%

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