Hi there,
I hope somebody can shed some light to my problem.
I have a table which contains:
Employee
Request #
Date Opened
Date Closed
My requirement is to count the # by Employee on a specific date the number of Request Opened and Closed but the count for Opened should not count anything closed on the specified date to prevent duplicate counts.
My hope for the report should sort of appear like:
Employee:
Adam
Date Opened - 15
Date Closed - 10
Totals - 25
Joe
Date Opened - 5
Date Closed - 21
Totals - 26
Thanks in advance,
Kastaman
I hope somebody can shed some light to my problem.
I have a table which contains:
Employee
Request #
Date Opened
Date Closed
My requirement is to count the # by Employee on a specific date the number of Request Opened and Closed but the count for Opened should not count anything closed on the specified date to prevent duplicate counts.
My hope for the report should sort of appear like:
Employee:
Adam
Date Opened - 15
Date Closed - 10
Totals - 25
Joe
Date Opened - 5
Date Closed - 21
Totals - 26
Thanks in advance,
Kastaman