Customer Search Query and from

[Simon]

I have a query that is base a form on than lets me type in some one
surname ( Or firstname or Email address) and it will do the do a
search and dispaly any one with a surname similar

the query is

SELECT qryCustomers.CustomerNumber, qryCustomers.FirstName,
qryCustomers.LastName, qryCustomers.EmailAddress
FROM qryCustomers
WHERE (((qryCustomers.FirstName) Like "*" & [forms]!
[frmCustomersSearch]![FirstNameSearch] & "*") AND
((qryCustomers.LastName) Like "*" & [forms]![frmCustomersSearch]!
[SurnameSearch] & "*") AND ((qryCustomers.EmailAddress) Like "*" &
[forms]![frmCustomersSearch]![EmailSearch] & "*"));



The problem i have if is do a search for SMITH and smith does not have
a email addrees or first name it does not bring up any information

how do i get to serach for smith even if they do not have an emaila
address

thanks

Simon