Querying multiple queries, returning duplicates

[Gabriel2012]

Good morning, the issue I am faced with is outlined below:



Query #1 (This is already built and working)
Employee ID, Period, Totals, Productivity (this is a query because the "productivity" figure is a formula)

Query #2 (this is already built and working)
Employee ID, Period, CountOfError

I need to create a new "Accuracy Query" which pulls the "Totals" amount from Query #1 and the "CountOfError" from Query #2, puts them into a new query, grouped by employee ID and period, and than divides the "CountOfError" by the "Totals" to receive an accuracy rating.

The issue that I run into is that the Employee Id has multiple entries in both querys, so I receive duplicated results; any ideas? Thank you!

[jzwp11]

In Query 1, is there only 1 record for each combination of employee & period?
Is the same true for Query 2?


If the answer is yes to both questions above, create a new query and add both query 1 & query 2. Join the two queries by both Employee ID AND period and then select the fields you want in this new query and add your calculated fields as well.

If the answer is no to both questions, then you have to create an aggregate query for query 1 (and do the same using query 2) such that you end up with only 1 record per employee/period combination.

If this does not answer your question, it would be best if you can provide some example data from both your original query 1 & query 2 so that we can see what you data look like.

[Gabriel2012]

Your solution worked, many thanks!

[jzwp11]

You're welcome.