access 2003 complex query

5 pts.
Tags:
Microsoft Access 2003
Microsoft Access 2003 forms
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.

Software/Hardware used:
ms access 2003
ASKED: February 25, 2012  7:19 PM
UPDATED: February 27, 2012  7:44 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Not sure to understand your design, nor your problem. "My query is like this:Qualified: Sum(IIf([Result]="Pass";1;0))" and..., does it work ? Maybe posting some example data (along with the expected results) could help.
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following