Access 2013 query duplicating records

[jpreator]

I need to combine that data from 2 seperate queries. Each query is counting, one the number of employees in a department by shift and the other is counting the number of employees that have entered a help idea into the system. The problem I'm experiencing is that when I pull the data from one or both of the queries it is duplicating the records. When I run either of the queries that I'm pulling from they have no duplicates. Here is the sql from the two queries.

SELECT qDepartments.DeptName, qParticipationShiftCount.Shift, Count(qParticipationShiftCount.EmpID) AS CountOfEmpID1
FROM qDepartments INNER JOIN qParticipationShiftCount ON qDepartments.DeptName = qParticipationShiftCount.DeptName
GROUP BY qDepartments.DeptName, qParticipationShiftCount.Shift
HAVING (((qDepartments.DeptName)<>"Primer Manager" And (qDepartments.DeptName)<>"Centerfire Manager" And (qDepartments.DeptName)<>"Rimfire Manager" And (qDepartments.DeptName)<>"HR"));
 

SELECT Department.DeptName, dbo_MasterEmployeeList.Shift, Count(dbo_MasterEmployeeList.EmpID) AS CountOfEmpID
FROM (Department INNER JOIN DepNumber ON Department.DeptName = DepNumber.DeptName) INNER JOIN (dbo_MasterEmployeeList INNER JOIN dbo_vSiteAreaDeptDetail ON dbo_MasterEmployeeList.SiteAreaDeptID = dbo_vSiteAreaDeptDetail.SiteAreaDeptID) ON DepNumber.[Dept#] = dbo_MasterEmployeeList.Department
WHERE (((dbo_vSiteAreaDeptDetail.SiteID)=15))
GROUP BY Department.DeptName, dbo_MasterEmployeeList.Shift, dbo_MasterEmployeeList.Status
HAVING (((dbo_MasterEmployeeList.Status)="A"));
 

Here is the code for the query that is pulling the data. The minute I load the 2nd table, even if I do not use any of it's fields it starts causing the query to duplicate repeatedly.

SELECT qParticipationShift2PlusCount.DeptName, qParticipationShift2PlusCount.Shift, qParticipationShift2PlusCount.CountOfEmpID1
FROM qParticipationShift2PlusCount, qParticipationShiftEECount;
 

[jforbes]

You'll probably want to use a Union instead of including both tables in the FROM clause.

When you add multiple tables to the FROM clause instead of Joining the additional tables, a row for each combination of rows in the supplied tables is returned. So if you have Ten Rows in qParticipationShift2PlusCount and Four Rows in qParticipationShiftEECount you will get a result set of Forty Rows.

Using a Union is fickle as you need to have the same amount of columns in the two constituting result sets as well as the column names have to match one for one.

[NeoPa]

SQL JOINs gives some more info on how best to work with JOINs, as well as a description of the cartesian product result set that you have and JForbes described.