Access Web App: Trouble with counting.

[akdatabaser]

Okay, so I have a main table that records task data.






It looks up one of these departments.




I then entered this bogus data, so I can do some testing.




What I really want to do is create a datasheet that shows the number of tasks for each dept, and then also include the number of employees that performed tasks in each dept. This is my first query and results are just fine. Sorry, just now noticed that is is not being counted correctly. Not sure why.




But this is the second/sub query where I would have assumed that the employees would have been counted and I have no idea what is going on...





Ultimately, what I really want to see is basically this:

Department	Count of Task A	Count of Task B	Count of Employees
Dept 1	2	3	2
Dept 2	1	0	1
Dept 3	1	1	1

If this were SQL I would just count the tasks for each department and then count the distinct employee numbers, but since this is access web app, I don't really have that option. So, how do I go about achieving this seemingly simple task?

My google searches on everything related to queries and criteria have been very disappointing. There is not a lot of support for access web app.


Thanks so much!