Report to show total employees with total reports

[wayne.labanca]

OK,
My manager is looking for a report that will show all employees and
next to their names, show the total call monitoring reports that have
been completed on them.

I think I need to use the emplyees table to get the names and then the
calls table to get the count of how many calls have been monitored on
each. I just can't figure out how to tie the two together and get the
proper counts to show next to the correct employee.

Thanks,
Wayne

 

[Duane Hookom]

If you can't figure how to tie the tow together, I'm not sure how you can
expect us to figure this out. You can see your tables, fields, data
values,... and we don't have a clue.

 

[wayne]

I'm not really sure what to provide, here goes:

The report would show all of the employees that are in the employees
table. What I want to be able to do is have another field in the report
that can count how many entries are in the calls table that match a
name in the employees table.

So if John Doe has had 5 calls monitored, the report would show:

John Doe(because he exists in the employees table) 5(because there
are 5 entries in the calls table with his name in them)


If Jane Smith had no calls monitored:

Jane Smith 0 (Or nothing would be fine also.)

Just a basic comparison, I just don't know how to do it.

Wayne

 

[Duane Hookom]

Do you have a field in your calls table that can be linked to your employee
table? Your employee table should have a primary key field. The value from
this field should be stored in a field in your calls table. You can create a
query with these two tables and join them based on these fields. Then change
your query to a totals query and group by your employee name and count the
EmployeeID field from the Calls table.