Hi,
I'm a beginner here, I'm trying to create a query to count the feedback outstanding for a given team leader. Where there is feedback outstanding the below returns the number of items.
When there isn't any feedback the query doesn't return anything. I need the query to return 0 instead. How can I make this work?
The SQL code for the query at the moment is:
I'm using MS Access 2010 if that helps.
Any suggestions you can offer would be greatly appreciated.
Many thanks in advance
I'm a beginner here, I'm trying to create a query to count the feedback outstanding for a given team leader. Where there is feedback outstanding the below returns the number of items.
When there isn't any feedback the query doesn't return anything. I need the query to return 0 instead. How can I make this work?
The SQL code for the query at the moment is:
Code:
SELECT Count(Feedback.ID) AS CountOfID, UserIDAgentsTLsLocations.TeamLeader, Feedback.Fedback
FROM UserIDAgentsTLsLocations INNER JOIN Feedback ON UserIDAgentsTLsLocations.UserID = Feedback.AgentUsername
GROUP BY UserIDAgentsTLsLocations.TeamLeader, Feedback.Fedback
HAVING (((UserIDAgentsTLsLocations.TeamLeader)="David Green") AND ((Feedback.Fedback)=False));
I'm using MS Access 2010 if that helps.
Any suggestions you can offer would be greatly appreciated.
Many thanks in advance