Open Dental Forum

How can I look for hygiene production (not by provider) buyt by what is picked as hygiene procedure?

Would this work?

/*126*/ SET @FromDate='2016-01-01' , @ToDate='2016-06-30';
SELECT Count(*),pv.Abbr, pc.ProcCode, pc.AbbrDesc, AVG(pl.ProcFee) as '$Ave. Fee' , SUM(pl.ProcFee) AS '$Tot. Prod' FROM patient
INNER JOIN procedurelog pl ON patient.PatNum=pl.PatNum
INNER JOIN procedurecode pc ON pl.CodeNum= pc.CodeNum
INNER JOIN provider pv ON pl.ProvNum=pv.ProvNum
WHERE pl.ProcStatus = '2' AND (pl.ProcDate >=@FromDate
AND pl.ProcDate <= @ToDate) AND pc.IsHygiene=1
GROUP BY pc.ProcCode
ORDER BY ProcCode;

drtmz

Almost...when I run the report though, my total for the month is over $80,000 which I know is not correct....what am i doing wrong?