Query Help Needed

[coyote1x]

I have built several queries to count the number time yes is checked for a line item. When I run the individual query it works perfectly. I want a report of the combined queries. When I combined the queries the data no longer displays. Can someone please help me figure this out. Below is the sql of the combined query.

SELECT tblSiteName.SiteName, tblManager.ManagerName, tblSupervisor.SupervisorName, tblAssociate.AssociateName, [Comprehensive Count].[Count Of tblIQForm], [Customer Interaction Success Rate].[1-1 Yes].CountOfAssociateName, [Customer Interaction Success Rate].[1-2 Yes].CountOfAssociateName, [Customer Interaction Success Rate].[1-4 Yes].CountOfAssociateName, [Customer Interaction Success Rate].[1-3 Yes].CountOfAssociateName, [Customer Interaction Success Rate].[1-5 N/A].CountOfAssociateName, [Customer Interaction Success Rate].[1-5 Yes].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-1 Yes].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-1 N/A].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-4 Yes].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-4 N/A].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-2 Yes].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-3 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-1 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-2 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-2 N/A].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-3 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-4 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-5 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-6 Yes].CountOfAssociateName
FROM ([Internal Process/Procedures Line Item Success Rate] INNER JOIN ([Assessment and Issue Solving Line Item Success Rate] INNER JOIN ([Customer Interaction Success Rate] INNER JOIN ((((tblSiteName INNER JOIN tblManager ON tblSiteName.SiteID = tblManager.SiteID) INNER JOIN tblSupervisor ON tblManager.ManagerID = tblSupervisor.ManagerID) INNER JOIN tblAssociate ON tblSupervisor.SupervisorID = tblAssociate.SupervisorID) INNER JOIN tblIQForm ON tblAssociate.AssociateID = tblIQForm.AssociateID) ON [Customer Interaction Success Rate].AssociateName = tblAssociate.AssociateName) ON [Assessment and Issue Solving Line Item Success Rate].AssociateName = tblAssociate.AssociateName) ON [Internal Process/Procedures Line Item Success Rate].AssociateName = tblAssociate.AssociateName) INNER JOIN [Comprehensive Count] ON tblAssociate.AssociateID = [Comprehensive Count].AssociateID
WHERE (((tblIQForm.DateOfInteraction) Between [Enter Beginning Date:] And [Enter Ending Date:]))
GROUP BY tblSiteName.SiteName, tblManager.ManagerName, tblSupervisor.SupervisorName, tblAssociate.AssociateName, [Comprehensive Count].[Count Of tblIQForm], [Customer Interaction Success Rate].[1-1 Yes].CountOfAssociateName, [Customer Interaction Success Rate].[1-2 Yes].CountOfAssociateName, [Customer Interaction Success Rate].[1-4 Yes].CountOfAssociateName, [Customer Interaction Success Rate].[1-3 Yes].CountOfAssociateName, [Customer Interaction Success Rate].[1-5 N/A].CountOfAssociateName, [Customer Interaction Success Rate].[1-5 Yes].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-1 Yes].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-1 N/A].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-4 Yes].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-4 N/A].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-2 Yes].CountOfAssociateName, [Assessment and Issue Solving Line Item Success Rate].[2-3 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-1 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-2 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-2 N/A].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-3 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-4 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-5 Yes].CountOfAssociateName, [Internal Process/Procedures Line Item Success Rate].[3-6 Yes].CountOfAssociateName, tblIQForm.AssociateID;

 

[dhookom]

It's near impossible to determine where your joins or criteria are limiting your data. You need to
-begin by removing criteria
-remove a table at a time until you see the results you expect
-once you get the results you expect, begin adding back in one table at a time to find your data issue

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

You may have to consider LEFT JOIN instead of INNER JOIN

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244