I have a Query that lists all of the current Employees.
I have a separate query that lists all of the activities done in a month with Employee ID Number, ActivityDescription, and Type Description
I added to the Query with All Employees several fields that show DCount results: example:
Code:
Demo: DCount("[ScheduleID]","Q2ActivityTeam","[PersonnelID]=" & [PersonnelId] & "AND [ActivityDescription]='Demo' And [TypeDescription]='Appt'")
What I want is the employee Name plus a count of about 6 different types of activities. I am doing it with DCount because:
1. If the employee has no activity I want it to display 0's
2. There are multiple criteria for each activity (I am taking the information from a Sql DB)
It is working like I want - but the DCounts are SLOW
And if you click on the Query or resize it - it refreshes
Is there a better way? I tried a form with the DCounts - just as slow and would not export to excel.