I have a log table which has a date complete and a checkbox for all of the tasks that were done for each job.
Job Road Stream line complete
1 yes no yes 4/1/02
2 Yes yes no 5/1/02
3 Yes no yes 5/2/02
I want to count all of the tasks that were completed each month by task. so the result I am looking for would be:
Month Road Stream line
April 1 0 1
May 3 1 1
I know this is simple just never done it and don't have time to play to figure it out. Any help would be appreciated
Job Road Stream line complete
1 yes no yes 4/1/02
2 Yes yes no 5/1/02
3 Yes no yes 5/2/02
I want to count all of the tasks that were completed each month by task. so the result I am looking for would be:
Month Road Stream line
April 1 0 1
May 3 1 1
I know this is simple just never done it and don't have time to play to figure it out. Any help would be appreciated