Complex Access query required

Master table has fields:
Report_No,Product_ID,Test_Date
Detail table has fields:
Report_Det,Report_No(Foreign key),Serial_No,Quantity,Result
Results table has records:
Pass,Fail,R&D,InProcess
Detail table have 1,2 or 3 records with different result against each record in Master table.
I want to create a query to count Reports from master having Results=Pass, Fail, R&D, InProcess and Mix i-e one Report can contains some Products Pass and some Fail.This particular report should not be counted in Reports with Result Pass or Fail.
My query is like this:Qualified: Sum(IIf([Result]="Pass";1;0))
but how to count reports with result Pass and Fail?
I can send small database also.