Master table has fields:
Detail table has fields:
Results table has records:
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.