i have a query i created for a system awhile back in SQL on acces, this is the coding:
SELECT [Table].[owner], Count(*) AS Totalcalls
GROUP BY [table].[owner], [table].[date]
HAVING ((([table].[date])=[Enter Date]));
im wondering how would the code be written if im also including [Sale] which is a tick box, from the ones its counted how many of them have [sale]=-1 and group them into each owners results.