I hope u can modify the query as
SELECT PersonID, FirstName, NickName, MiddleName, LastName
FROM Person
WHERE 0=0
AND Upper(LastName) NOT LIKE 'MODEM'
AND FirstName LIKE '%#Form.Name#%'
OR LastName LIKE '%#Form.Name#%'
OR NickName LIKE '%#Form.Name#%'
ORDER BY LastName
I'm sure this would...