Display all records

[skwilliamson]

I have a main table "tblEmp" with a list of all employees. I also have a table "tblReprints" with individual errors detailed by person. Not every employee will have errors. I would like to run a query to display all employees and their errors.

For example:
tblEmp contains Name1, Name2, Name3 and Name4

tblReprints contains 2 records (errors) for Name1 and 1 record (error) for Name2.



The query would display something like this:
Employee Errors
Name1 2
Name2 1
Name3 0
Name4 0

If an employee doesn't have any errors, the query would display 0

[SoftwareMatters]

Create a new query and add the 2 tables and select the join which shows all the records from tblEmp and ony those records from tblReprints where the fields match.
Add the unique ID form both tables
Switch on grouping.
Do a group by on the tblEmpID field
Do a count on the tblReprints ID field

[skwilliamson]

Thanks for the help.

[RuralGuy]

Is your issue resolved? Are you ready to follow the link in my sig and mark this thread as Solved?