Report summary count with multiple criteria

[crimedog]

I have 2 tables - Rep Table (that lists all of he Reps and whether they are active) and Tasks


The Task Table lists Customer Task Rep Completion Date for each record

I need a summary report that lists all active Reps and a count of the Number of completed (has date) tasks
There are 3 tasks - install, repair, report - so it should look like this:

Smith Installs: 5 Repairs: 3 Reports: 10
Jones Installs: 3 Repairs: 5 Reports: 10
etc...

DCount will only allow for criteria
I can do a Query all records with a completion date - but how to get a count for each task?

[June7]

That looks like output that can be generated by CROSSTAB query.

Did you try a report using its grouping & sorting features with aggregate calcs in footer sections?

Show example of raw data.