Query to find "not null" email fields in 2 fields AND by another criteria

Hi All,
I have a table with our prospects in.  Each prospet has 2 email fields and a campaign name field. I'd like to write a query that searches for records based on AND & OR criteria.  i.e - All records that campaign=camaign1 and email1=is not null OR email2=is not null.

Here is what i have so far: WHERE (((TAB_Prospects.[Campaign Name])="MF_Crane_Hire_01") AND ((TAB_Prospects.Email) Is Not Null)) OR (((TAB_Prospects.Email1) Is Not Null))

This query does not work ... please help!!Start Free Trial

1:
2:
3:
4:

SELECT TAB_Prospects.[Campaign Name], TAB_Prospects.[Company Name], TAB_Prospects.Title1, TAB_Prospects.FirstName1, TAB_Prospects.LastName1, TAB_Prospects.Email, TAB_Prospects.Email1
FROM TAB_Prospects
WHERE (((TAB_Prospects.[Campaign Name])="MF_Crane_Hire_01") AND ((TAB_Prospects.Email) Is Not Null)) AND (((TAB_Prospects.Email1) Is Not Null))
ORDER BY TAB_Prospects.[Company Name];