Complex Access query required
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums
Results 1 to 1 of 1

Thread: Complex Access query required

  1. #1
    Join Date
    Feb 2012

    Complex Access query required

    Master table has fields:
    Detail table has fields:
    Report_Det,Report_No(Foreign key),Serial_No,Quantity,Result
    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.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

On-Demand Webinars (sponsored)