i think this is the report that i need but it seems to be broken right now. Is there anyone that can help me fix it?
SELECT procedurelog.ProcDate,patient.ChartNumber,CONCAT(patient.LName,
', ',patient.FName,' ',patient.MiddleI) AS plfname, procedurelog.ADACode,
procedurelog.ToothNum,procedurecode.Descript,provider.Abbr,
procedurelog.ProcFee-SUM(claimproc.WriteOff) AS $fee
FROM procedurelog,patient,procedurecode,provider
LEFT JOIN claimproc ON procedurelog.ProcNum=claimproc.ProcNum
AND claimproc.Status='7'
WHERE procedurelog.ProcStatus = '2'
AND patient.PatNum=procedurelog.PatNum
AND procedurelog.ADACode=procedurecode.ADACode
AND provider.ProvNum=procedurelog.ProvNum
AND procedurelog.ProcDate = '2005-07-29'
GROUP BY procedurelog.ProcNum
ORDER BY procedurelog.ProcDate,plfname
thank you