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

Thread: Complex Access query required

  1. #1
    Join Date
    Feb 2012
    Posts
    2

    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.
    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
  •  


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center