I have a query with 3 fields. Name, Mobile, and E-Mail. I want to add a criteria that returns only those records where at least one of the Mobile and E-Mail fields has data. HELP
I have a query with 3 fields. Name, Mobile, and E-Mail. I want to add a criteria that returns only those records where at least one of the Mobile and E-Mail fields has data. HELP
SELECT tClients.Name, tClients.PhoneCell, tClients.EmailWk
FROM tClients
WHERE (((tClients.Email) Is Not Null)) OR (((tClients.PhoneCell) Is Not Null));
How is this added? I tried to put it in the Criteria box under the Name field but it does not work there.
in the criteria,
field 1 (email) , on 1st criteria, put: NOT NULL
field 2 (phone) , on 2nd SEPARATE line criteria (NOT THE SAME LINE AS ABOVE) , put: NOT NULL
Thats what makes the 'OR'.
I tried just the IS NOT NULL statements and that solved the problem. Thank You!!!!