select [call].[Assigned-to (Team)], [call].[Call Type], Count(*)
from [call] where [call].[Open_date] > date()-7 and [call].[Assigned-to (Team)] = 'pmoc'
group by [call].[Assigned-to (Team)], [call].[Call Type]
This should work as sql.
select [call].[Assigned-to (Team)], [call].[Call Type], Count(*)
from [call] where [call].[Open_date] > date()-7 and [call].[Assigned-to (Team)] = 'pmoc'
group by [call].[Assigned-to (Team)], [call].[Call Type]
This should work as sql.
-----------------------------------------
The more you learn about something the more you know you have much to learn.
Posting Permissions
Reply With Quote