Using multiple drop downs as criteria in a query to also work individually.

[sashapixie]

Hi There

I have two drop down menus linked to a query criteria, they work together no problem however they will not work as a single entity. I have added or criteria to look at the lists singularly which works but when you introduce the second criteria I returns the singular result and the joint result. The SQL is below, any help would be appreciated.

SELECT [Project Records].[PEQ Number], [Project Records].Status, [Project Records].[Project Title], [Project Records].[M/E], [Project Records].Client, [Project Records].[Date Received], [Project Records].[Date Requested], [Project Records].[Date Submitted], [Project Records].[Mechanical Works], [Project Records].[Electrical Works], [Project Records].[Builders Works], [Project Records].[Provisional Sums], [Project Records].Preliminaries, [Project Records].[Design Fees], [Project Records].[Record Comments], [Project Records].[Grand Total], [Project Records].[Financial Year]
FROM [Project Records]
WHERE ((([Project Records].[Project Title]) Is Not Null) AND (([Project Records].[Financial Year])=[Forms]![Estimating Menu]![CmbYearSelector])) OR ((([Project Records].Status)=[Forms]![Estimating Menu]![CmbStatusTenderMenu]) AND (([Project Records].[Project Title]) Is Not Null)) OR ((([Project Records].Status)=[Forms]![Estimating Menu]![CmbStatusTenderMenu]) AND (([Project Records].[Project Title]) Is Not Null) AND (([Project Records].[Financial Year])=[Forms]![Estimating Menu]![CmbYearSelector]));